[SOLVED]How do I merge text in columns?

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24

i'd like to know of a way to merge 3 columns of text into one word per row without absolutely any spaces. Greatly appreciate any help on this.

Robert Tucker · Posted: Mon Dec 20, 2010 5:05 am Post subject:

The CONCATENATE function?

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_CONCATENATE_function
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24

thanks for the reply, didnt kno the function

but

when i type in =CONCATENATE (A1; B1; C1)

into the function box

i get Err:509 in the selected cell.

Also, I'm looking for a way to concatenate each cell of column

And when I type in

=CONCATENATE(A; B; C)

I get #NAME

JohnV · Posted: Mon Dec 20, 2010 6:33 am Post subject:

Shortcut is = A1&B1&C1.

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24

Ok, i was actually trying to get this in result in A1, which meant it corrupted the equation, as A1 was on the other side of the equal sign too.

However, I'd like to know how to do this in bulk

I now know how to add one row

= A1&B1&C1

but when I try to add the entire columns

think

= A&B&C

I get #NAME

thanks for your responses, but I'm just a step away from what i want,.

Robert Tucker · Posted: Mon Dec 20, 2010 6:46 am Post subject:

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24

thanks for the drag down advice.

however i still can't get the main stuff right

i'm getting:

plz, help? im doomed..

Robert Tucker · Posted: Tue Dec 21, 2010 12:41 am Post subject:

I think you need:

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24

unfortunately that doesnt work either

i get

#VALOR

u cannot believe how annoying small INEXPLICABLE problems are!!

thanks anyway Sad

keme · Posted: Tue Dec 21, 2010 2:53 am Post subject:

jirimenzel · General User Joined: 05 Dec 2010 Posts: 24