| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE ALL EXCEPT LETTER OF A WORD
How can I delete all except the first letter of words in a column?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DELETE ALL EXCEPT LETTER OF A WORD
a macro something like sub firstletteronly() for each c in range("a2:a22") c.value=left(c,1) next c end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "jerrybee57" wrote in message ... How can I delete all except the first letter of words in a column? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DELETE ALL EXCEPT LETTER OF A WORD
In a helper column enter =LEFT(A1) and copy down.
Select the helper column and copy it. Select the original column and EditPaste SpecialValuesOKEsc Delete helper column. Gord Dibben MS Excel MVP On Tue, 18 Aug 2009 13:28:01 -0700, jerrybee57 wrote: How can I delete all except the first letter of words in a column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert letter/no among word | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| delete series of letter in spreadsheet | Excel Worksheet Functions | |||
| How do I get the first letter of a word in excel | Excel Discussion (Misc queries) | |||
| how to delete the 1st letter form a set of rows of info. | Excel Worksheet Functions | |||
Linear Mode
