View Single Post
 
Old 08-28-2017, 02:17 PM
delivery delivery is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Aug 2017
Posts: 4
delivery is on a distinguished road
Default 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?
Reply With Quote