Paste Several Values into one Cell

[Guest]

Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy all of this data into one cell as it appears now (in a particular sequence). Is this possible? Thx in advance.

 

[Philip Reece-Heal]

Not sure if this is what you want but to concatenate data from several cells
into 1 cell, use formula =Concatenate(I2," ",H2," ",G2) just add more cell
references with commas and " " to give a space between each cell value for
all the cells you want.

Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy

all of this data into one cell as it appears now (in a particular sequence).
Is this possible? Thx in advance.

 

[Guest]

Thanks, but that function won't allow over 30 arguments. I have much more than that to enter. Is there some other way to do it? Thanks again.

 

[Dave Peterson]

=a1&" "&b1&" "&c1&" "&d1&" "&text(e1,"yyyy/mm/dd")

(you can use =text() to include the formatted version of the cell, too.)

=concatenate(upto30)&" "&concatenate(30more)
Until your done