??? 2.jpg
How to extract text between brackets/parentheses in Excel?
??? 2.jpg
How to extract text between brackets/parentheses in Excel?
Hiii Done... see attached sheet
Formula:Please Login or Register to view this content.
Don`t care, take care...
Regards,
Mangesh
b2=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,LEN(A2)-1),"(",REPT(" ",25)),"[",REPT(" ",25)),25))Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
[ ... deleted ... ]
Last edited by sandy666; 10-19-2015 at 03:22 AM.
something wrong, I cannot edit my own post, so... ignore post above.
my 2¢'s
B2:with CSE (Control+Shift+Enter)Please Login or Register to view this content.
Last edited by sandy666; 10-19-2015 at 03:21 AM.
Hi mangesh.mehendale
Thank you
Hi nflsales
Wow! excellent.Thank you
Hi sandy666
That's all right.Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks