I have a column that has the data formatted like this: (This is a different column than previous post)
Smith, John M Smith, Alex Jones, Mary Jackson Harris, Greg P Diaz-Garcia, Brenda Maria T etc I want it to look like this (Note these are separate columns and those having two last names have no spaces instead of a space of hyphen, I can fix this in find and replace if needed) John Smith M Alex Smith Mary Jones Greg JacksonHarris P Brenda DiazGarcia Maria T Thanks you for any help. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
