=LEFT(A1,1)

copy down and paste special as values in place once you are done

replace A1 with the cell that contains the first name

--


Regards,


Peo Sjoblom

"Felecia" <Felecia @discussions.microsoft.com wrote in message
...
I am trying to keep the first letter of each name in a column. I have
approximately 1600 different first names in this column and I want to keep
the first letter of each name. I will be using this to create usernames.

I did it last year but just can't remember how, LOL!

Thanks, Felecia