Thread: Stripping data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_5_] Stuart[_5_] is offline
external usenet poster
 
Posts: 413
Default Stripping data

How best to achieve this, please:

data is of the type 999 102A and is the only entry
in a cell.

I would like to strip the data to end up with 2 options,
either 102A or just A.

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.576 / Virus Database: 365 - Release Date: 30/01/2004