FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,364
- Office Version
- 365
- 2016
- Platform
- Windows
I’m trying to build a text string out of some cell, but Idon’t want the blank cells to appear.
In the first table I have an a-value and two x-values. Pretty easy to create the sting.
123.45 + 15.34(x1) + 12.44(x2)
=B1&" +"&B2&"("&A2&") +"&B3&"("&A3&")"
Data Range
<tbody>
</tbody>
In the second table there is only one x-value. Is there a way to ignore the blank cells andjust get the one x-value?
15.34(x1)
Data Range
<tbody>
</tbody>
In the first table I have an a-value and two x-values. Pretty easy to create the sting.
123.45 + 15.34(x1) + 12.44(x2)
=B1&" +"&B2&"("&A2&") +"&B3&"("&A3&")"
Data Range
A | B | |
1 | a | 123.45 |
2 | x1 | 15.34 |
3 | x2 | 12.44 |
<tbody>
</tbody>
In the second table there is only one x-value. Is there a way to ignore the blank cells andjust get the one x-value?
15.34(x1)
Data Range
A | B | |
1 | a | |
2 | x1 | 15.34 |
3 | x2 |
<tbody>
</tbody>
Last edited: