LinkBack URL
About LinkBacks
In cell B1 I want to search a cell for " (" within cell A1 and when it finds it return everything to the left of it. In cell C1 I want to search for "(" and ")" and return everything between these characters. What formula is required for this?
In cell B1 I want to search a cell for " (" within cell A1 and when it finds it return everything to the left of it. In cell C1 I want to search for "(" and ")" and return everything between these characters. What formula is required for this?
Try this
=LEFT(A1,SEARCH("(",A1))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In B1-
In C1-
Please Login or Register to view this content.
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Awesome. Feedback left, solved.
as a bonus another version for between ( )Originally Posted by ScabbyDog
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,")","("),"(",REPT(" ",255)),255*1,255))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks