Try this one
Formula:
=TRIM(MID(SUBSTITUTE(IF(ISERR(FIND(",",A2))," "&A2,A2)," ",REPT(" ",50)),50,50))
v A B 1 Name 2 John Q Smith John 3 Bob Allen Jones Bob 4 William B Howard William 5 Smith, Brian L Brian 6 Jones, Evan R Evan 7 Gray, David S "Buddy" David 8 Smith, Billy R Billy 9 Smith, Billy A "Ben" Billy
Last edited by AlKey; 05-17-2018 at 05:03 PM.
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
That works perfect. Thank you. :-)
Hello again,
I was using your formula and it was working great. However, I got an erroneous result when I encountered a name like:
Smith Jr., Billy A "Ben"
The formula returns the value "Jr.".
I tried messing with the formula to get it to work but no avail.
Your help would be greatly appreciated.
Who's formula did you use?Originally Posted by rmichra
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
=trim(mid(substitute(if(iserr(find(",",a2))," "&a2,a2)," ",rept(" ",50)),50,50))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks