If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?

A formula will do

Assuming you have spaces between commas and names,
=MID(A2,FIND(",",A2)+2,FIND(",",A2,FIND(",",A2)))& RIGHT(A2,FIND(",",A2,FIND(",",A2)))&", "&LEFT(A2,FIND(",",A2)-1)

Then just copy down. If you want this more permanent, copy the cells with
formulas, right click, paste special.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"David" wrote:

If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?

Hi

No macro is needend.
With the names in column A enter this formula in column B1 and copy
down as needed.

=MID(A1,SEARCH(",",A1;1)+2,100) & ", " & LEFT(A1,SEARCH(",",A1)-1)

Then copy column B, select A1 and goto Paste Special Select "values"
Ok, then column B can be deleted.

HTH,

Per

On 6 Jan., 21:43, David wrote:
If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?

You could always split the cell into 3 columns by going to Data, then text to
columns and adjust that way as well.

"David" wrote:

If names are in cells as "last name, first name, middle initial" can a macro
be run to change the order to "first name, middle initial, last name"?