View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zcoleschuler zcoleschuler is offline
external usenet poster
 
Posts: 2
Default Typing an Address List

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