| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get text which is inside the brackets in excel sheet
Hi all,
I am having field values like below, xyz(xxx) abc(rrrr) pqr(as) my need is to get string which is inside the bracket. xxx rrrr as How can i get this values, plz help me on this regard |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get text which is inside the brackets in excel sheet
=SUBSTITUTE(MID(A1,SEARCH("(",A1,1)+1,100),")","")
-- If this post helps click Yes --------------- Jacob Skaria "arun" wrote: Hi all, I am having field values like below, xyz(xxx) abc(rrrr) pqr(as) my need is to get string which is inside the bracket. xxx rrrr as How can i get this values, plz help me on this regard |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to get text which is inside the brackets in excel sheet
=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1) if it always ends with the
closing parenthesis, or =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) -- David Biddulph "arun" wrote in message ... Hi all, I am having field values like below, xyz(xxx) abc(rrrr) pqr(as) my need is to get string which is inside the bracket. xxx rrrr as How can i get this values, plz help me on this regard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to enter text inside the bars on a bar chart in Excel? | Charts and Charting in Excel | |||
| Display external data inside of an Excel 2007 Spread sheet | Excel Worksheet Functions | |||
| inserting scrollbar inside an Excel Sheet | Excel Discussion (Misc queries) | |||
| VLOOKUP used with Access DB inside of Excel Sheet | Excel Discussion (Misc queries) | |||
| While rotating object, how to rotate the text inside - in excel | Excel Discussion (Misc queries) | |||
Linear Mode
