S
sgarrett
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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.
Is this possible? Thx in advance.
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.
all of this data into one cell as it appears now (in a particular sequence).sgarrett said:Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy
Is this possible? Thx in advance.
S
sgarrett
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.
D
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
(you can use =text() to include the formatted version of the cell, too.)
=concatenate(upto30)&" "&concatenate(30more)
Until your done