I would like to use vlookup to look for all the characters at the right of a
column until the (:) sign, (see sample below) I cant use the num_chars
because its not always the same amount of characters after the colon sign
(:)

FISH IN BAGS:12a
FISH IN BAGS:P24
FISH IN BOX:P12
FISH IN BAGS:PN24

Do yoiu mean:

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

to give:

12a
P24
P12
PN24

when dragged down?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mottyb" wrote in message
...
I would like to use vlookup to look for all the characters at the right of
a
column until the (:) sign, (see sample below) I can't use the num_chars
because it's not always the same amount of characters after the colon sign
(:)

FISH IN BAGS:12a
FISH IN BAGS:P24
FISH IN BOX:P12
FISH IN BAGS:PN24

Maybe:-

=RIGHT(A1,LEN(A1)-FIND(":",A1,1))

Mike

"Mottyb" wrote:

I would like to use vlookup to look for all the characters at the right of a
column until the (:) sign, (see sample below) I cant use the num_chars
because its not always the same amount of characters after the colon sign
(:)

FISH IN BAGS:12a
FISH IN BAGS:P24
FISH IN BOX:P12
FISH IN BAGS:PN24