Posted to microsoft.public.excel.misc

davids

Posts: n/a

Splitting data out of a single cell

I was wondering if there was a formula I could use in excel to split data out
from a single cell into multiple cells

ie Sydney NSW 2000 (Currently All in one cell)
Would like to know how to split "Sydney" into it's own cell,"NSW" into its
own cell and respectively "2000" into its own cell

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
Excel Macro to Copy & Paste	[email protected]	Excel Worksheet Functions	0	December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Excel Worksheet Functions	7	September 3rd 05 03:47 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Splitting Data in a Cell	Newbie1092	Excel Worksheet Functions	3	May 10th 05 05:48 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

All times are GMT +1. The time now is 04:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us