« Copying Formulas while preserving references | Main | Rounding Numbers to Thousands and Millions »
February 06, 2005
Text manipulation 1 : Concatenation
There are two methods available for concatenating text.The ampersand symol & can be used as a concatenation operator on text - as shown below. This is analogous to the + operator for numbers.
There is also a CONCATENATE function - which can be used on up to 30 strings. The CONCATENATE function is also shown in the example below.
Posted by Dave at February 6, 2005 05:30 AM