View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TC[_11_] TC[_11_] is offline
external usenet poster
 
Posts: 2
Default Extract a section of a text string to anew column - Excel 2003

Hi Gurus

I would really appreciate if I could have a VBA script/ Macro that
will do the following:-

Extract eg 32MPA , 20MPA , 40MPA fro a text string as per below
sample.

POST TENS 32MPA 20MM 22@3 90 AIR TESTED
GREEN 60 20MPA 20MM
CONCRETE_POLISHED___32MPA_10MM_SHRINKAGE LTD
CONCRETE_DURAMIX___40MPA_20MM_MACFOLSPEC

Thanking you in anticipation.

Cheers
Tony