ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
Hi board,
Groovy new format....
A question if I may, I have a reference number: ABC123(HH), I want to look up the original data listed with just the ABC123 part of the reference. I currently have a control column where I use 'text to columns' and use the first bracket as the delimiter. It's a bit clunky, I'm sure that there is a more elegant solution.
Can you assist.
bob
Groovy new format....
A question if I may, I have a reference number: ABC123(HH), I want to look up the original data listed with just the ABC123 part of the reference. I currently have a control column where I use 'text to columns' and use the first bracket as the delimiter. It's a bit clunky, I'm sure that there is a more elegant solution.
Can you assist.
bob
