| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
| Combining data from several worksheets | New Users to Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
