Maybe you could use a formula:
=LEFT(A1,1)&MID(A1,SEARCH(" ",A1),255)
dave glynn wrote:
I have a list of names that includes at leats one first name.
I need to reduce the first name to its initial so that my list which is
William Smith
Joseph Bloggs
etc
becomes
W Smith
J Bloggs
etc...
Thanks
Dave Glynn
--
Dave Peterson
|