Name formats

[MissPigitheDiva]

This will be easy peasy for some that KNOW and UNDERSTAND Excel. I am follow directions but I can not figure this out. The spreadsheet that was sent to me has a column that contains, Last Name, First Name, Initial. Is there a formula to change the name format to First Name, Initial, Last Name? Or put First Name in another column and Last Name in another column?

[FDibbins]

Hi, welcome to the forum

If I understand you correctly, and name...Last, First, initial...is all in the same cell, then you will need a formula to do what you want, but it will need to be done in another cell, you will not be able to change that in the same cell - unless you want to use some VBA code.

Any suggestion will also depend on the layout of your data, for instance...
is there always an initial
is there a . after the initial
etc

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[MissPigitheDiva]

Sure.... Here is a sample. Can you help me write the formula to change this automatically?

[Tony Valko]

This works in your sample file...

=TRIM(MID(SUBSTITUTE(F2,",",REPT(" ",100)),75,75))&" "&LEFT(F2,FIND(",",F2)-1)

Copy down.

[FlameRetired]

Another way.

This is a strategy I picked up from AlKey (I think).

=PROPER(SUBSTITUTE(TRIM(MID(SUBSTITUTE(F2&"/"&F2,", ",REPT(" ",99)),99,99)),"/"," "))

[MissPigitheDiva]

Is that to inject into a blank cell beside the name?

[MissPigitheDiva]

Yes Flame!! This one did work! Thank you! WOOT WOOT!

[FlameRetired]

Your welcome. Glad I could pass it along. Thanks for the feedback.

[MissPigitheDiva]

SOLVED Thank you for your help