I have a list of names in excel such as
Bill Smith
Joe Bloggs
Jock McTavish
The entire name (forename and surname) is contained in one cell.
The forename and surname are "space" delimited.
How do I convert the forenames to initials so that the list will read
B Smith
J Bloggs
J McTavish
Thanks
Dave Glynn
Bookmarks