View Single Post
  #2   Report Post  
Old July 26th 11, 10:07 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
First recorded activity by ExcelBanter: Dec 2006
Posts: 620
Default removing zeroes almost perfect

On 26/07/2011 20:55, pat67 wrote:
Hi I am using this to convert BHQ0009540 to C9540


the issue is sometimes i need a leading 0 like converting LPB0000385
to C0385. using the above I get C385.

I am at a loss. any ideas?


="C"&TEXT(RIGHT(B2,7),"0000") if this suits the input format.

David Biddulph