Posted to microsoft.public.excel.programming

Randy Patterson Randy Patterson is offline

external usenet poster

Posts: 2

cell splitting

I have one cell which contains the first and last name separated by a space.
I want to change this into two separate cells. The names are all different
lengths. I am unable to find any command to do this. Sort of a backwards
concatenate. Does anyone know how to do this?

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
splitting my cell	rodchar	Excel Discussion (Misc queries)	5	July 22nd 08 03:24 PM
Splitting a Cell	williamr	Excel Worksheet Functions	2	June 13th 07 01:30 AM
splitting cell	anand	Excel Worksheet Functions	2	June 1st 07 11:13 PM
Splitting a cell	David	Excel Worksheet Functions	2	March 16th 06 07:36 PM
splitting a cell into 2	alldreans	Excel Programming	4	May 4th 04 10:24 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us