Re: Return Consecutive Values - Pairs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Re: a regex question ..
    ... Geoff Cox schrieb: ... > I am trying to rename a list of files by changing any single digits in ... Prev by Date: ...
    (comp.lang.perl.misc)
  • a regex question ..
    ... I am trying to rename a list of files by changing any single digits in ... Geoff ... Prev by Date: ...
    (comp.lang.perl.misc)