ExcelBanter - Formula to change Name format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to change Name format (https://www.excelbanter.com/excel-discussion-misc-queries/233561-formula-change-name-format.html)

Kiley

Formula to change Name format

I have the name:

Smith,Jane A

and I would like a formula that changes it to:

Jane A Smith

Luke M

Formula to change Name format

Try:

=MID(A2,FIND(",",A2)+1,256)&" "&LEFT(A2,FIND(",",A2)-1)
--
Best Regards,

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

"Kiley" wrote:

I have the name:

Smith,Jane A

and I would like a formula that changes it to:

Jane A Smith

Kiley

Formula to change Name format

Thank you so much!

"Luke M" wrote:

Try:

=MID(A2,FIND(",",A2)+1,256)&" "&LEFT(A2,FIND(",",A2)-1)
--
Best Regards,

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

"Kiley" wrote:

I have the name:

Smith,Jane A

and I would like a formula that changes it to:

Jane A Smith

All times are GMT +1. The time now is 03:25 PM.