I have a list of names, roughly 10k rows, mostly in the format of LastName, FirstName which I am using the find and replace function to remove the "," so I can get into the format of LastName FirstName with no comma separating them. However some of the names are in the format LastName,FirstName with no space in between. In this scenario when I use find and replace the name Smith John becomes SmithJohn which is a problem. I cannot deliminate by comma and then trim because I also have company names mixed into this list. I have researched wildcards but can't seem to come up with a formula to work.
Is there a formula where I can change all the occurrences of LastName,FirstName into LastName, FirstName or at least mark there position in a column next to them. This problem does not seem to occur too often but my list is so large even marking their position with a unique character or word where I could then search and manually add the space would save a ton of time. Thanks for any help in advance.
Bookmarks