How do I keep the first letter of each word in that column.

[Felecia]

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

 

[Peo Sjoblom]

=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

 

[Don Guillett]

Look in the help index for LEFT

 

[Gary''s Student]

If column A contains the names, then in B1 enter:

=left(A1,1)