Posted to microsoft.public.excel.programming

[email protected] kathy.aubin@gmail.com is offline

external usenet poster

Posts: 26

Value between two spaces in a String

Hi,

I have string like that :

NESN 380.7 STR 01/28/2008

and I want to be able to grab the value between the first two spaces;
380.7. I know how to find the first space but I don't know how to find
the second one.

Does anyone know?

Thanks,

Kathy

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
Find String in another string - only between spaces	Nir	Excel Worksheet Functions	9	November 2nd 06 11:31 AM
Removing Spaces from string	katmando	Excel Worksheet Functions	4	May 16th 06 02:16 PM
counting spaces in a string	xnman	Excel Programming	7	May 9th 04 03:06 PM
counting spaces in a string	xnman	Excel Programming	4	December 16th 03 01:36 AM
Count Spaces In A String	Josh in Tampa	Excel Programming	2	October 23rd 03 05:59 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us