| View previous topic :: View next topic |
| Author |
Message |
AhrenBa
General User
Joined: 18 Sep 2007
Posts: 19
|
 Posted: Mon Apr 07, 2008 6:19 am Post subject: How do I combine two columns into one? |
 |
|
Hey guys,
If I have columns that looks like this (| separates the column in this post):
Doe | John
Doe | Jane
How do I combine the two so that it looks like this:
Doe John
Doe Jane
(one column)
Thanks. |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Mon Apr 07, 2008 6:22 am Post subject: |
|
|
You can either use the CONCATENATE( ) function or the & symbol.
=CONCATENATE(A1;A2)
or
=A1&A2
To get a space between them:
=A1&" "&A2 |
|
| Back to top |
|
|
AhrenBa
General User
Joined: 18 Sep 2007
Posts: 19
|
| Posted: Mon Apr 07, 2008 6:24 am Post subject: |
|
|
| RickRandom wrote: | You can either use the CONCATENATE( ) function or the & symbol.
=CONCATENATE(A1;A2)
or
=A1&A2
To get a space between them:
=A1&" "&A2 |
Awesome! Thanks man! It worked!  |
|
| Back to top |
|
|
|
