The name being in B22
=MID(B22,SEARCH(" ",B22)+1,LEN(B22)--SEARCH(" ",B22))&"_"&LOWER(LEFT(B22,2))
Regards,
Stefi

€žChris€� ezt Ã*rta:

Hi All,

I would like to know if its possible for Excel to take a persons name and
format it so it will take the first 5 letters of the Surname and the first 2
letters of the first name and produce the formatted result into an empty
cell.. i.e

Chris Jones = jones_ch

there must be a "_" inbetween the surname and first name.

Any help on this would be great.

Thank you.
Chris