Separate First and Last and how to add to existing Macro
I recorded a macro to do some basic functions but need to add in something to it.
I have names in column I. Some are first last , first middle last, first middle (two names) last
I just want the first name in column J and the last name in column K ignoring whatever middles names are there if any. How do I tell it to do it to the entire I column?
Where would I insert that into my record macro? Right before End Sub?
|