How to separate names and addresses in a spreadsheet
 

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
--
Bajan Boy

How to separate names and addresses in a spreadsheet
 

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 DataText to Columns
Select: Delimited
Next
Select: Comma
Finish

--
Biff
Microsoft Excel MVP


"Basil" wrote in message
...
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
--
Bajan Boy