Typing an Address List

[zcoleschuler]

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

 

[JMB]

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

copy down

 

[T. Valko]

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 menu>Copy
Right mouse click menu>Paste Special>Values>OK

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

 

[zcoleschuler]

Worked perfect! Thanks

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

copy down