I am trying to merge data from 3 different columns but haven't a clue how to do it! HELP
N Nigel Mar 17, 2006 #1 I am trying to merge data from 3 different columns but haven't a clue how to do it! HELP
E ewan7279 Mar 17, 2006 #2 Hi Nigel, You can concatenate the columns using the ampersand thus: =A1&B1&C1. If you want spaces between the data, do: =A1&" "&B1&" "&C1. Ewan.
Hi Nigel, You can concatenate the columns using the ampersand thus: =A1&B1&C1. If you want spaces between the data, do: =A1&" "&B1&" "&C1. Ewan.
