Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

parsing full names in to 3 columns

hello,

this is a newbie question.

I have a column in excel,

ADAMS, LILLIAN ROZANN
ANDERSON, SUSAN M
ANDERSON, THOMAS J
BAANDERS, BONDIANA F
BEAN, JODY LYNN
BECKER, BETTE J
BERGSENG, ARTHUR M
BERGSENG, CAROL N

I need to parse the last name, first name and middle name(intial) in to
seperate columns.

What would be the best course of action for this?

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
parsing a full name out into Last, First, Middle	Craig	Excel Worksheet Functions	2	July 29th 09 12:57 AM
Formulas for Parsing Full names	jonefer	Excel Worksheet Functions	3	February 14th 06 06:28 AM
how do I find names in a workbook full of names	aj	Excel Discussion (Misc queries)	1	January 19th 06 09:01 PM
TypeLib Information Problem? Pass a Function's parameter names as string for parsing?	Ali G	Excel Programming	1	December 3rd 04 07:02 PM
Parsing Full Names of varying lenths and parts	Dan	Excel Programming	1	October 24th 03 06:26 PM

All times are GMT +1. The time now is 03:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us