Hi,
I'm new to programming. I'm using Excel 2003. I'm trying to parse out parts of a name string.
The name string is in the following format:
YYMMDD_SN###_###_BB####_Summary.xls
- The name string is in Column A.
- I want the SN portion to be copied to Column B. The SN number may be variable length.
- I want the BB portion to be in Column C. The BBnumber may be variable length.