Look in the help index for LEFT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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