[Solved] Concatenate

Discuss the spreadsheet application

[Solved] Concatenate

Postby THEBookMan » Tue Feb 12, 2019 8:34 pm

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
Last edited by THEBookMan on Tue Feb 12, 2019 8:58 pm, edited 1 time in total.
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: Concatenate

Postby THEBookMan » Tue Feb 12, 2019 8:41 pm

Key word is "CONSOLIDATE".

but, doesn't seem to work!
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)

Re: Concatenate

Postby Zizi64 » Tue Feb 12, 2019 8:46 pm

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
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8145
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Concatenate

Postby THEBookMan » Tue Feb 12, 2019 8:57 pm

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.
Open Office 4.1.3 Win 10
THEBookMan
 
Posts: 80
Joined: Wed Sep 30, 2015 10:03 pm
Location: GB, WI (some sort of sport team lives around here)


Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests