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

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

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

=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

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

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

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

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

=left(A1,1)
--
Gary''s Student - gsnu200799