Hello Excel friends,
I'd greatly appreciate if someone can show me how to write a macro in VBA to go to each cell in COLUMN E beginning with ROW 3 and replacing ", " (that's a comma followed by a space which separates Lname and Fname) with ",{alt-enter}".
What I'm doing with this is replacing the space following the first (and only) comma in the NAME field with an ALT-ENTER to put the Fname/Mname on the second line of the cell.
Schmoe, Joseph Chris will become:
Schmoe,
Joseph Chris.
Thanks very much for any assistance!
Bookmarks