Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 60
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,646
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Separating names Stewart99 Excel Discussion (Misc queries) 2 August 17th 07 01:53 AM
separating first and last names Tom G. Excel Discussion (Misc queries) 10 September 4th 06 04:20 PM
Separating Names in a Cell Motaad Excel Discussion (Misc queries) 3 August 17th 06 04:26 PM
separating names mikeyVo Excel Worksheet Functions 2 July 20th 06 04:46 PM
Separating names Danno Excel Worksheet Functions 5 October 31st 05 12:29 AM


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"