View Single Post
 
Old 08-24-2009, 08:41 AM
themangoagent themangoagent is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2009
Posts: 9
themangoagent is on a distinguished road
Default

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!
Reply With Quote