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.

"Nigel" wrote:

I am trying to merge data from 3 different columns but haven't a clue how to
do it!
HELP