Hello all,

I use a certain function enough on my excel sheets, I no longer want to copy and paste but to just use a macro to insert my function. The original data is formatted like this:

FirstName LastName
FirstName LastName
FirstName LastName

The function I am using is:
=CONCATENATE(MID(A1,FIND(" ",A1)+1,256),", ",LEFT(A1,(FIND(" ",A1,1)-1)))

The function turns my original data into:

LastName, FirstName
LastName, FirstName
LastName, FirstName

I would like to come up with a simple macro that runs a for each loop that inserts the function in column B based on column A. If you know of an easier way, I am all ears!

Thank you.