I typed my list to look like this:

Salutation First Name Last Name
Mr. & Mrs. Charles Skipsey
Mr. & Mrs. Paul Deutz
Mr. & Mrs. Bill Rolston
Mr. & Mrs. Hugh Siler
Mr. & Mrs. Charles Erwin

On this page, Salutation is in A1, First Name in B1, and Last Name is in C1

Is there a way to change the format to where I combine the 3 cells into A1?:


Ex:
Mr and Mrs Charles Skipsey

select a cell in column A and insert a new column, then use
=Substitute(B2,"&", "and")&" "&C2&" "&D2

copy down


"zcoleschuler" wrote:

I typed my list to look like this:

Salutation First Name Last Name
Mr. & Mrs. Charles Skipsey
Mr. & Mrs. Paul Deutz
Mr. & Mrs. Bill Rolston
Mr. & Mrs. Hugh Siler
Mr. & Mrs. Charles Erwin

On this page, Salutation is in A1, First Name in B1, and Last Name is in C1

Is there a way to change the format to where I combine the 3 cells into A1?:


Ex:
Mr and Mrs Charles Skipsey

You can get there in a couple of easy steps....

Enter this formula in D1 and copy down to the end of data in column C:

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

Now, select the entire range of these formulas
Right mouse click menuCopy
Right mouse click menuPaste SpecialValuesOK

Inspect the results, if they're OK then you can delete the original data


--
Biff
Microsoft Excel MVP


"zcoleschuler" wrote in message
...
I typed my list to look like this:

Salutation First Name Last Name
Mr. & Mrs. Charles Skipsey
Mr. & Mrs. Paul Deutz
Mr. & Mrs. Bill Rolston
Mr. & Mrs. Hugh Siler
Mr. & Mrs. Charles Erwin

On this page, Salutation is in A1, First Name in B1, and Last Name is in
C1

Is there a way to change the format to where I combine the 3 cells into
A1?:


Ex:
Mr and Mrs Charles Skipsey

Worked perfect! Thanks

"JMB" wrote:

select a cell in column A and insert a new column, then use
=Substitute(B2,"&", "and")&" "&C2&" "&D2

copy down


"zcoleschuler" wrote:

I typed my list to look like this:

Salutation First Name Last Name
Mr. & Mrs. Charles Skipsey
Mr. & Mrs. Paul Deutz
Mr. & Mrs. Bill Rolston
Mr. & Mrs. Hugh Siler
Mr. & Mrs. Charles Erwin

On this page, Salutation is in A1, First Name in B1, and Last Name is in C1

Is there a way to change the format to where I combine the 3 cells into A1?:


Ex:
Mr and Mrs Charles Skipsey