Extract text inside bracket
this may work for you
a1 contains (thirsty)
put this in a2
=REPLACE(REPLACE(A1,1,1,""),LEN(A1)-1,1,"")
--
Gary
"Kumaras" wrote in message
oups.com...
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
|