Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

parsing a string for 3 sets of numbers

I have a spreadsheet with various words and numbers in each cell. The
arrangement of numbers in the string can vary. I want to extract from the
text string, the first 3 numbers as numbers.

Example

dog a cat 45672 223 12.42 mouse caught

I want to parse the above string (which is in a cell) and get
45672
223
12.42

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
Parsing a string	simonc	Excel Programming	4	March 27th 06 08:04 AM
Need help parsing a string	Daminc[_38_]	Excel Programming	4	January 26th 06 11:53 AM
help parsing multiple text sets from one cell	[email protected]	Excel Worksheet Functions	0	August 31st 05 05:17 PM
parsing a string	Mark[_57_]	Excel Programming	4	April 28th 05 04:42 PM
Parsing a String to get Numbers	nabukhalaf[_2_]	Excel Programming	4	October 6th 04 12:05 AM

All times are GMT +1. The time now is 03:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us