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?