|
combining data
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com