View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DMcCormack DMcCormack is offline
external usenet poster
 
Posts: 3
Default how do I insert a zero ie 01535-1A to 01535-01A

There are probably easier ways but you could use a concatenate formula e.g.
if the "01535-1A is in cell A1 then use:
=CONCATENATE(LEFT(A1,6),0,RIGHT(A1,2))

"Mike" wrote:

how do I insert a zero ie 01535-1A to 01535-01A