Tuesday, May 19, 2009

Combining Text Strings with Worksheet Data

Though I have used Excel's CONCATENATE function to combine values and text strings on
a routine basis, I recently saw in another spreadsheet that the use of the & symbol is a little easier to follow when building the string.

Rather than =CONCATENATE("The value in Cell A2 is", TEXT(A2,"0.00"))

I can simply type="The value in Cell A2 is"&TEXT(A2,"0.00")

For me the ampersand(&) makes it much easier to follow and there isn't the issue of matching the right and left parenthesis.

Not an earth shattering find, but a valuable one none the less! ;-)