View Single Post
  #4   Report Post  
Sam via OfficeKB.com
 
Posts: n/a
Default

Hi Domenic,

I forget to say why I tweaked nested LEFT Function in Formula - there are a
couple of Input cells with single digits, so they were tweaked with LEFT(B$1,
1). The Formula remains as your Posting for all double digit values. Based on
the values shown in my Posting your Formula was spot on!

Thanks
Sam

--
Message posted via http://www.officekb.com