Merge three fields into one

  • Thread starter Thread starter Stockwell43
  • Start date Start date
S

Stockwell43

Hello,

I had someone ask me a question and I don't know the answer but hoped one of
you might. On a spreadsheet the user has three separate columns one for
"First Name", one for "Middle Initial" and one for "Last name". They want to
have all three field or first name, middle initial and last name all in one
field. Is there a way to do this? I tried to higlight and copy into one cell
and didn't and that is my best shot. Any help would be most appreciated.

Thanks!!!
 
For example if those 3 fields are in column A, B, C

In column D write the formula

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

And then just copy and paste that formula down to wherever you want it
 
=A1&'' "&B1&" "&C1

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello,
|
| I had someone ask me a question and I don't know the answer but hoped one of
| you might. On a spreadsheet the user has three separate columns one for
| "First Name", one for "Middle Initial" and one for "Last name". They want to
| have all three field or first name, middle initial and last name all in one
| field. Is there a way to do this? I tried to higlight and copy into one cell
| and didn't and that is my best shot. Any help would be most appreciated.
|
| Thanks!!!
 
That worked like an absolute charm!!

Your Genius!! Thank you very much for your help. You just made someone very
happy!
 
Back
Top