Hi, I have a list of names with this format: john doe (jdoe) and I only need the jdoe without the parentheses. The current formula i'm using is right(trim(f2),len(trim(f2))-find("(",trim(f2))) but it's giving me jdoe).. Help please, thanks!
Hi, I have a list of names with this format: john doe (jdoe) and I only need the jdoe without the parentheses. The current formula i'm using is right(trim(f2),len(trim(f2))-find("(",trim(f2))) but it's giving me jdoe).. Help please, thanks!
Try this...
A1 = john doe (jdoe)
=SUBSTITUTE(MID(A1,FIND("(",A1)+1,25),")","")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Works OK for me...
Last edited by Tony Valko; 05-26-2015 at 09:07 PM. Reason: Why does the image get enlarged?
Here's a sample file created in Excel 2010:
Ohh! I missed 1 parentheses.. I'm so sorry.. Thanks a heap for the quick reply Tony! It's working now..
Good deal. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks