Name change

[PRASHANT RAWAT]

Hi,

Need help to solve the problem

Please find the attachment

[#2]

Please check this https://excelribbon.tips.net/T012383_Separating_Names_into_Individual_Columns.html

[#3]

But need one formula to solve the problem

[#4]

Why formulas in the article don't work with you?