Allan Walker
New Member
- Joined
- Jun 10, 2010
- Messages
- 49
Hi,
I am trying to extract any string inside an open bracket ( and closed bracket ) in a cell. The cell data can contain a string prefixing the open bracket, but thankfully, there is no string suffixing the closed bracket.
The string lengths inside and outside the brackets are variable in the dataset, otherwise I would have been able to do a "RIGHT" or "LEFT" or "MID", so now I'm stuck!
Prior
Result
I am using Office 2003 with Windows XP SP3
Many thanks in advance,
Allan
I am trying to extract any string inside an open bracket ( and closed bracket ) in a cell. The cell data can contain a string prefixing the open bracket, but thankfully, there is no string suffixing the closed bracket.
The string lengths inside and outside the brackets are variable in the dataset, otherwise I would have been able to do a "RIGHT" or "LEFT" or "MID", so now I'm stuck!
Prior
Excel Workbook | ||||||
---|---|---|---|---|---|---|
G | H | I | J | |||
1 | MARY COOK(PR271) | * | YASMIN AKHTAR (YA1) | * | ||
2 | BETTY YATES(WD305) | * | YASMIN AKHTAR (YA1) | * | ||
3 | JOAN OWEN(PR304) | * | YASMIN AKHTAR (YA1) | * | ||
4 | AVTAR SINGH(WD401) | * | YASMIN AKHTAR (YA1) | * | ||
5 | HILDA *YOUNG(WD405) | * | YASMIN AKHTAR (YA1) | * | ||
6 | PERCY COLEMAN(WD410) | * | YASMIN AKHTAR (YA1) | * | ||
7 | AUGUSTA BELL(WD273) | * | YASMIN AKHTAR (YA1) | * | ||
Sheet 1 |
Result
Excel Workbook | ||||||
---|---|---|---|---|---|---|
G | H | I | J | |||
1 | MARY COOK(PR271) | (PR271) | YASMIN AKHTAR (YA1) | (YA1) | ||
Sheet 1 |
I am using Office 2003 with Windows XP SP3
Many thanks in advance,
Allan