C
Chris
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
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