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

[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