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
24
FISH IN BOX
12
FISH IN BAGS
N24
column until the

because it’s not always the same amount of characters after the colon sign

FISH IN BAGS:12a
FISH IN BAGS

FISH IN BOX

FISH IN BAGS
