ok... now to throw a wrench into it...
I just looked at all the cells I need to do this for and they aren't all the same...
I added a few more examples. The numbers in brackets are consistent, (0-9) but the values before the first parenthesis is different and varying length.
Example:
A
1 U(9)
2 M(8)
3 C(7)
4 D3.6.0(7)
5 W++(8)
6 W++(7)
7 D0.1+++(9)
My lookup table:
A B C
1 U All users
2 M Management
3 C Consultants
4 D3.6.0
5 D0.1+++
6 W++
7 7 Read Only
8 8 Full Access
9 9 Read & Write
Is this still doable??? I'm guessing to use an expression search, "look at all characters before the first open parenthesis"?
Thanks,
Stephanie
|