| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change first letter of a word for an entire column | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Hybrid Mode
