Posted to microsoft.public.excel.misc

external usenet poster

Posts: 6

Data Arrangement

I have text in a cell that is in the format:
LastName FirstName MiddleName (ex. Willson James Nichols).

Is there a way to switch the text to:

FirstName MiddleName LastName (ex. James Nichols Willson)?

Thanks.
--

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
Arrangement problems.	Blah	Excel Worksheet Functions	0	April 25th 06 12:21 AM
Arrangement	harvindersingh1	Excel Discussion (Misc queries)	2	April 18th 06 07:46 AM
Data Arrangement	tbobo	Excel Discussion (Misc queries)	3	March 23rd 06 02:50 PM
Re-arrangement	William	Excel Discussion (Misc queries)	4	October 26th 05 09:11 AM
Worksheet re-arrangement	Malcolm Brown	Excel Worksheet Functions	2	November 13th 04 10:09 AM

All times are GMT +1. The time now is 10:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us