Posted to microsoft.public.excel.misc

Joe in CT

Posts: n/a

separate address data in a cell

Greetings, I have this information in one cell-
777 Anywhere Street
Happy Town, CT
The only comma is just after town. I need to separate out into street
addresss, town and state. How do I do this?

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
Urgent date/scheduling calc needed	jct	Excel Worksheet Functions	3	February 24th 06 01:36 AM
cell address	ellebelle	Excel Worksheet Functions	5	February 2nd 06 11:23 PM
Split data from one cell to two separate cells	Michele	Excel Worksheet Functions	2	October 25th 05 09:27 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

All times are GMT +1. The time now is 08:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us