Use If & Mid or Right functions or combinations thereoff......

D

Dave

Hi All,

I have some data in cell A13 as follows:

Sometimes its :

PRIOR-RECIPT--> 00000000000 SP-INT--> 123456789

& Sometimes its :

NOT REQ FILE PRIOR-RECIPT--> 00000000000 SP-INT-->
000000000

I must pull out the 11 digit PRIOR-RECIPT number either way.


Thanks a bunch ,
Dave
 
Top