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

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

Extract text inside bracket
 

forgot it was in the middle of the sentence, my formula wouldn't work
--


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

Extract text inside bracket
 

Kumaras,

This might work for the bracket problem-

In cell A1 let it equal, I am (thirsty) for water.

In cell A2 enter the formula, MID(A1, FIND("(",A1,1)+1,
FIND(")",A1,1)-FIND("(",A1,1)-1)

Explanation of terms-
FIND("(",A1,1)+1, : Finds the position of the first parenthesis, "(",
then add one for the first letter after "(". This finds the start_num
of the text in A1.
FIND(")",A1,1) : Finds the position of the second parenthesis, ")"
FIND(")",A1,1)-FIND("(",A1,1)-1 :Subtract the second position value
minus the first value, then subtract one. This determines the num_char
starting with the start_num value.

Best regards,

RichardG



==========
Kumaras wrote:
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

Extract text inside bracket
 

I'm assuming you meant parentheses not brackets, right?

These are parentheses - ( )
These are brackets - [ ]
These are braces - { }

Extract text inside bracket
 

Paul,

Thanks for the clarification on parentheses, brackets and braces. I
should be more careful.
I would think that the formula would work regardless which one is used,
as long as the formula is properly coded.

Best regards,

RichardG


Paul D. Simon wrote:
I'm assuming you meant parentheses not brackets, right?

These are parentheses - ( )
These are brackets - [ ]
These are braces - { }