Extract text inside bracket
Hello,
First
I would like extract only text inside bracket and copy to the adjacent
or next column in EXCEL.Eg as shown below:
I am (thirsty) for water.
Now only thirsty needs to be copied to next column, Can it be done by
formulae.
Second doubt,
For below Eg,
ITEM TAG NO. DWG. NO.
1 11HS051A, 11XA054A 00A1CD001W51
2 11HS051B, 11XA054B 00A1CD002W52
3 11HS601A, 11XA603A 00A1CD003W53
I would like to look have it as below,what is the easiest way to do
this in excel
ITEM TAG NO. DWG. NO.
1 11HS051A 00A1CD001W51
2 11XA054A 00A1CD001W51
3 11HS051B 00A1CD001W52
4 11XA054B 00A1CD002W52
5 11HS601A 00A1CD001W53
6 11XA603A 00A1CD003W53
Thanks in advance,
Akumar
|