Sorry I was not clear - the data *is* in column J
Carmel

"Bob Phillips" wrote:

That will work as long as it is not in J2 or J3.

--
HTH

Bob Phillips

"Carmel R" wrote in message
...
Is there a way I can combine data from the same column? I know how to
concatenate, but that only seems to work between columns. I would,
ideally,
like to run the following: =J2&" "&J3.....
Is there a function in Excel or in VBA which can do this?
Thanks in advance for your help!
Carmel R