ExcelBanter - Excel Formula Help

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formula Help (https://www.excelbanter.com/excel-worksheet-functions/128036-excel-formula-help.html)

BSAT Student

Excel Formula Help

I have a list of names as lastname, firstname. I need a formula to make them
first initial (no period) lastname. Does anyone know of an Excel formula or
function that will do this?

Thanks

Fred Smith

Excel Formula Help

The following formula should do what you want:

=MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1)

--
Regards,
Fred

"BSAT Student" wrote in message
...
I have a list of names as lastname, firstname. I need a formula to make them
first initial (no period) lastname. Does anyone know of an Excel formula or
function that will do this?

Thanks

BSAT Student

Excel Formula Help

Thank you so much! It worked perfectly!!!

"Fred Smith" wrote:

The following formula should do what you want:

=MID(A1,FIND(",",A1)+2,1)&" "&LEFT(A1,FIND(",",A1)-1)

--
Regards,
Fred

"BSAT Student" wrote in message
...
I have a list of names as lastname, firstname. I need a formula to make them
first initial (no period) lastname. Does anyone know of an Excel formula or
function that will do this?

Thanks

All times are GMT +1. The time now is 04:00 PM.