LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Easily mailing list from Data File

I would like to downloaded data (from our county's data base) and create a
mailing list. The downloaded data needs to be converted into First Name,
Middle Initial, Last Name.

For instance, here is a typical downloaded strings:

Grant Ulysses S.
Truman Harry S.

I want to get it to First Name, Middle Initial, Last Name. The result would
be used in mail merge and imported into Word. The final product would be:

First Name Middle Initial Last Name
Ulysses S. Grant
Harry S. Truman

How can this be executed in Excel? What functions are needed and what are
the formulas?

(I figures out how to handle the first space but cannot determine the next
formulas.)

Thanks for your help.
--
Dave
Cincinnati, OH
 
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
I need to import my Excel Mailing list into mailing label format. Gord Dibben Excel Discussion (Misc queries) 0 November 5th 09 10:16 PM
I need to import my Excel Mailing list into mailing label format. Lyn Excel Discussion (Misc queries) 0 November 5th 09 08:11 PM
Updating mailing list data David_Morrison Excel Discussion (Misc queries) 0 November 22nd 06 10:13 PM
How do I convert a list of data into mailing labels? Kim G Excel Worksheet Functions 2 April 21st 06 06:03 PM
How do I get data list to print mailing labels? John Nichols Excel Discussion (Misc queries) 1 December 15th 05 04:19 PM


All times are GMT +1. The time now is 07:26 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"