combining data

C

Carmel R

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
 
B

Bob Phillips

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