Separating names & addresses in a spreadsheet

B

Basil

Hi:

I have a spreadsheet with names and addresses which I need to use in a merge
letter. Both (the names and addresses) have commas that separate the fields
I need to use. I understand these commas can be used to separate information
into columns. How do I do so?

Thanks
 
S

Stefi

See Data>Text to columns, separated by comma!
Regards,
Stefi

„Basil†ezt írta:
 

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

Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
How to separate names and addresses in a spreadsheet 1
Is this possible? 0
Format column widths from one table to a separate table on same page 1
Grouping Names in Mail Merge 0
Lookup or search using the * character 1

Top