Thread: How do I automatically add a prefix to cell value in Excel?
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 How do I automatically add a prefix to cell value in Excel?
FormatCellsNumberCustom "CDA"0


Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 07:18:01 -0700, KimG wrote:

If I have a list in which the first characters repeat, (i.e. CDAxxxx), how do
I make it so that I only have to type the xxxx and the CDA is automatically
prepended?

Reply With QuoteReply With Quote