How to separate names and addresses in a spreadsheet

[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

 

[T. Valko]

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