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

How to separate names and addresses in a spreadsheet 1
Extracting Address data from single cells 2
New to VLOOKUP ...merge addresses? 1
Insert a semicolon in lieu of ALT Enter 4
Separating data in the same cell 1
HOW TO I COPY SPRADSHEET WITH EMAILS AND NAMES TO MY CONTACTS 2
Names and addresses 5
Exporting email addresses 3

Top