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