Posted to microsoft.public.excel.programming

Prema

external usenet poster

Posts: 26

separate mixed data

I have following data in one cell. 672 15 73.53 49412.16 17.5 8647.13
In this eaxmple there are 6 data elements. Each one could be of varying
length and separated by at least one space (but would vary). I would likie to
know how I could extract each data element separately.

Thank you.

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
Sumproduct with mixed data?	gooders	Excel Worksheet Functions	6	April 25th 10 03:42 PM
Charting mixed data	Darlene	Charts and Charting in Excel	1	August 27th 08 06:14 PM
Save 2 separate data imports in separate worksheets on the same ex	Jay	Excel Worksheet Functions	1	March 8th 06 01:31 PM
SORT MIXED DATA	jem	Excel Worksheet Functions	3	March 23rd 05 10:41 PM
Mixed Data Handling	easy	Charts and Charting in Excel	2	March 16th 05 03:21 AM

All times are GMT +1. The time now is 11:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us