vlookup left

M

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 BAGS:p24
FISH IN BOX:p12
FISH IN BAGS:pN24
 
P

Pete_UK

This is not a LOOKUP nor a VLOOKUP. Check your earlier thread - you
have two replies there already.

Pete
 
Top