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
[Solved] Concatenate
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
[Solved] Concatenate
Last edited by THEBookMan on Tue Feb 12, 2019 8:58 pm, edited 1 time in total.
Open Office 4.1.3 Win 10
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: Concatenate
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
If the answer is YES, then you must use the function
=CONCATENATE(A1;A2;A3)
or
= A1&A2&A3
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 107
- Joined: Wed Sep 30, 2015 10:03 pm
- Location: Houston, TX area
Re: Concatenate
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.
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.
Open Office 4.1.3 Win 10