Hi,

I am trying to strip characters from a string upto a certain character
for instance :

CG016_30425 to become 30425
Hamblemeads_39450 to become 39450

Can anyone help ?

Thanks Simon.

=RIGHT(A1,LEN(A1)-FIND("_",A1))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

wrote in message
ups.com...
Hi,

I am trying to strip characters from a string upto a certain character
for instance :

CG016_30425 to become 30425
Hamblemeads_39450 to become 39450

Can anyone help ?

Thanks Simon.

Worked like a dream, thanks alot.