View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kathy.aubin@gmail.com is offline
external usenet poster
 
Posts: 26
Default 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