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