Posted to microsoft.public.excel.programming

dreamer[_17_] dreamer[_17_] is offline

external usenet poster

Posts: 1

extract string

I have a string that looks like this:

15;18;22;25

or like this

2;89

How can I extract it so it returns only the numbers from the string.
So in the first case it would be 15 18 22 25 etc..

--
Message posted from http://www.ExcelForum.com

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
extract numbers from a string	Dave	Excel Worksheet Functions	3	August 7th 08 09:43 PM
Extract given and surname a string	Bob Maloney	Excel Worksheet Functions	3	April 29th 07 03:27 AM
Extract from string	mark	Excel Discussion (Misc queries)	2	August 8th 06 12:38 PM
Extract sub string	sixbeforedawn	Excel Worksheet Functions	2	October 24th 05 09:50 AM
Extract Part of String	[email protected]	Excel Worksheet Functions	1	June 9th 05 08:33 AM

All times are GMT +1. The time now is 10:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us