Aargh!!!! of course!!!
Thanks for this!!!!!
Carmel

"Bob Phillips" wrote:

I meant as long as the formula is not in J2 or J3, else you get a circular
reference.

--
HTH

Bob Phillips

"Carmel R" wrote in message
...
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