How to separate names and addresses in a spreadsheet

  • Thread starter Thread starter Basil
  • Start date Start date
B

Basil

Hi:

I need to separate names and addresses in a spreadsheet which I want to use
as my source document for a merge letter. Both the names and addresses have
commas that separate the various fields and I understand I can use these
commas to separate the fields into columns. How do I do so?

Thanks
 
You can do this using the Text to Columns feature.

First, depending on how many separations there are per cell, you need to
make sure there are that many columns to the immediate right minus 1 that
are empty to receive the parsed data. Any data in those columns will be
overwritten!

Select the range of cells that you want to parse.
Goto the menu Data>Text to Columns
Select: Delimited
Next
Select: Comma
Finish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating names & addresses in a spreadsheet 1
Extracting Address data from single cells 2
What formula do I use to copy only text on left side of a comma? 4
number to character and vice-versa 8
Comma in Function Argument name treated as separator 1
Extract data from a cell 4
define name with 2 lists 2
How to filter Unique values from Duplicates 6

Back
Top