Thanks MikeWM! It's working quite well, except that Excel really doesn't like it if there isn't a comma. It returns an error: #VALUE!
Which is fine, but is there any way for it to copy the cell to the new column if there isn't any comma?
Example: Smith, John copies to the column as Dr. Smith, while Disneyland returns the error. Anyway to just copy Disneyland straight to the cell if there's no comma in the cell?
Thanks for your help!
|