On Wednesday, May 22, 2013 12:57:40 PM UTC-5, wrote:
Hello I need help I have names on my left and depending on the name I need to remove a space Original data Answer John, Repp John,Repp Jay, Thorp Jay, Thorp Jana, Washington Jana,Washington So just depending on the name some need the space after the "," trim and some dont I have a total of about 40 names only about 6 dont need the space after the coma. I was thinking of Replace and If But I cant seem to put it together.



Thank you Clause this works great