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! ;-)
Tuesday, May 19, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment