Page 1 of 1
[Solved] Concatenate
Posted: Tue Feb 12, 2019 8:34 pm
by THEBookMan
I have a SS w/ 3000 rows.
Each row has 3 columns.
I would like to concatenate all 3 columns into 1.
Not finding much help in the F1 page.
Any ideas
TNX,
⌡im
Re: Concatenate
Posted: Tue Feb 12, 2019 8:41 pm
by THEBookMan
Key word is "CONSOLIDATE".
but, doesn't seem to work!
Re: Concatenate
Posted: Tue Feb 12, 2019 8:46 pm
by Zizi64
Do you want concatenate three strings from three cells?
If the answer is YES, then you must use the function
=CONCATENATE(A1;A2;A3)
or
= A1&A2&A3
Re: Concatenate
Posted: Tue Feb 12, 2019 8:57 pm
by THEBookMan
This worked:
Select the cells you want to change.
Edit > Copy
Edit > Paste Special ... uncheck "Paste All", uncheck all EXCEPT "Values" ... OK
This is a handy trick in general for replacing a formula with its result.
Thanks.