Thread: DELETE ALL EXCEPT LETTER OF A WORD
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote