Good Morning!
What is the function or method to remove numbers that are not in parenthesis, from a cell? I have several thousand rows that I need to apply the function or method to.
Example: A1 = 123456 (623456) Gaserd
Desired answer: A1 = (623456) Gaserd
Thank you,
Jody
Here, use this:
Formula:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Hi there,
Your data in A1 and put formula below to B1 and drag down as needed:
Formula:Please Login or Register to view this content.
Hope it helps
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Or this
=REPLACE(A1,1,FIND("(",A1)-1,"")
Row\Col 123456 (623456) Gaserd (623456) Gaserd
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks