|
Written by David Noel-Davies
|
|
If you have text in two or more columns that you wish to join (concatenate) in another column, this can be easily done by creating a formula that utilizes the ampersand (&). I have found this to work in Microsoft Excel, OpenOffice’s Calc, and iWork’s Numbers. For our example, we will use a scenario where a list of users’ first and last names are given to you and your boss wants them to be in a single column instead of two. |
|
Read more...
|
