Menu

splitting text to multiple columns

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Don Guillett

Posts: n/a

Default

How about
datatext to columnsdelimitedspace

--
Don Guillett
SalesAid Software

"maryj" wrote in message
...
I have a list of people's names in a cell. Some examples a
Mr. John Doe
Mrs. Jane S. Smith
Ms. Cynthia Jones

I need to split their titles, first name with Middle initial and Last name
into 3 seperate columns. Using a post on this site, I was able to extract
the title, but am unsure how to pull the other information.

Thanks for you help!

Reply With Quote

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
Multiple font styles (superscript and subscript, for example)	Lorraine	Charts and Charting in Excel	0	January 13th 05 07:45 PM
Can I use side by side colums and stacked columns in same graph?	Debbie	Charts and Charting in Excel	1	December 29th 04 06:01 PM
How do I rotate a text box	Kent	Charts and Charting in Excel	2	December 17th 04 12:13 AM
Text Cuts Off	Jeff	Excel Discussion (Misc queries)	3	November 30th 04 02:07 AM
VBA Import of text file & Array parsing of that data	Dennis	Excel Discussion (Misc queries)	4	November 28th 04 10:20 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement