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.
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)
<[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks