Combining Text from Different Columns

dustinyoung

New Member
Joined
Nov 23, 2005
Messages
5
Hello.. first post here and probably and easy question. I'm combining 7 different spreadsheets. Some have the full name of a customer all in one cell. Others have columns for Mr./Mrs., First name, Last Name, MI, etc.

I want to take the ones with separate columns and comine them so that the salutation first and last name are all together, with spaces.

Can U help me? Thanks :)
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
That worked really good... one thing though.. some of the records don't have a salutation. For those, a space is in front of the name. How do I tell it to leave out the blanks?

Thanks again :biggrin:
 
Upvote 0
Not sure, perhaps you could filter the list by salutation, then try;
=B1&" "&C1

Colin.
 
Upvote 0
OK... this isn't working for me anymore because the cells with the combined info contain formulas .... let me start over. If I've got 2 columns, one with a first name the column next to it has a last name. How do I select the two columns and make it one column with a space between the names?
 
Upvote 0
You can use the formula as suggested. Then select the formulae column, copy, then paste special values only.
Would that work for you?
 
Upvote 0

Forum statistics

Threads
1,214,264
Messages
6,118,560
Members
448,836
Latest member
miclyzed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top