Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract text inside bracket
I'm assuming you meant parentheses not brackets, right?
These are parentheses - ( ) These are brackets - [ ] These are braces - { } |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - { } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract data from bracket | Excel Worksheet Functions | |||
How do I bracket text in cells by formatting a whole column? | Excel Worksheet Functions | |||
How can I extract characters from inside a cell? | Excel Worksheet Functions | |||
How do I extract 3 numbers inside a longer number to another column ? | Excel Discussion (Misc queries) | |||
Extract Informations inside a Borderframe | Excel Programming |