lookup left

[Mottyb]

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 BAGS24
FISH IN BOX12
FISH IN BAGSN24

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

Maybe:-

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

Mike