General discussion

Locked

Excel - Merging columns of text

By graham.moody ·
I have a worksheet of 3 columns of data: Title, First Name, Last Name. How can I merge these columns so that I have one column that contains all 3 fields, i.e Mr John Smith.

I know that you can parse text in the opposite direction to seperate names into different columns (using text to columns) but cannot find a way to do this in reverse.

Many thanks

Graham

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel - Merging columns of text

by tamj123 In reply to Excel - Merging columns o ...

you can used CONCATENATE funcation to join several columns into one.
example:
columns a1 : Mr/Mrs
columns b2 : abc
columns c3 : xyz
columns d4 : =CONCATENATE(a1,b2,c3))
result: Mr/Mrs abcxyz

Collapse -

Excel - Merging columns of text

by graham.moody In reply to Excel - Merging columns o ...

Thanks for the answer. Along the right lines but see answers 2 and 3 below.

Collapse -

Excel - Merging columns of text

by DKlippert In reply to Excel - Merging columns o ...

CONCATENATE is the answer, but you'll also want to insert spaces. Use the "&" operator.
=A1&" "&A2&" "&A3

Collapse -

Excel - Merging columns of text

by graham.moody In reply to Excel - Merging columns o ...
Collapse -

Excel - Merging columns of text

by Bill_H In reply to Excel - Merging columns o ...

There are a couple of ways to do this. First, (as previously mentioned), you can use the CONCATENATE function, and specify the cells to include.

The second approach is to use the concatenate operator, which is the ampersand (&amp. For example:

Cell A1: Robert
Cell B1: A.
Cell C1: Thomas

Place the following formula into cell D1:

=A1 & " " & B1 & " " & C1

D1 will now ontain the string "Robert A. Thomas". The inclusion of " " in the formula inserts a space (or whatever you includebetween the quotes) between the values of the cells specified.

It should be noted the previous answer would actually result in a string equal to "Mr/Mrsabcxyz". If you want the cell values to be separated by a space or other character(s), you will have to include them in the CONCATENATE function as well - unless you are *certain* that the cells *always* contain a trailing space, or your intention is to have the cell contents merged with no intervening value.

Collapse -

Excel - Merging columns of text

by Bill_H In reply to Excel - Merging columns o ...

Didn't see answer #2 when I posted - so the reference to the *previous answer* resulting in "Mr/Mrsabcxyz" actually refers to answer #1...

Collapse -

Excel - Merging columns of text

by graham.moody In reply to Excel - Merging columns o ...
Collapse -

Excel - Merging columns of text

by graham.moody In reply to Excel - Merging columns o ...

This question was closed by the author

Back to Windows Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums