ExcelBanter - Separating names & addresses in a spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Separating names & addresses in a spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/189898-separating-names-addresses-spreadsheet.html)

Basil

Separating names & addresses in a spreadsheet

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

Stefi

Separating names & addresses in a spreadsheet

See DataText to columns, separated by comma!
Regards,
Stefi

€žBasil€ ezt Ã*rta:

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

All times are GMT +1. The time now is 09:55 AM.