Combining Text from Different Columns

[dustinyoung]

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

 

[rs2k]

If they are starting in Col A,
=A1&" "&B1&" "&C1

Colin.

 

[dustinyoung]

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

 

[rs2k]

Not sure, perhaps you could filter the list by salutation, then try;
=B1&" "&C1

Colin.

 

[Datsmart]

How about:

=IF(A1 = "",B1&" "&C1,A1&" "&B1&" "&C1)

 

[dustinyoung]

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?

 

[Datsmart]

You can use the formula as suggested. Then select the formulae column, copy, then paste special values only.
Would that work for you?

 

[dustinyoung]

Thanks... i think that'll work fine. Sorry, I'm a newbie and don't know a lot of the basics.