Need a formula for a number range including a letter.

[RecordTechCJ]

I'm trying to create a form which will allow people to sign out pads of paper, the individual sheets on these pads are numbered with a letter and numbers. There are 30 sheets to a pad and I'd need the form eventually look like this:

Number Name Date
E123100 - E123129 John Smith 3-10-14
E123130 - E123159 Brian Jackson 5-22-14
E123160 - E123189 Jane Martin 6-2-14
E123190 - E123219 Ryan Williams 7-1-14



The name and date fields will be filled in by hand but I need the number fields to be a range with the letter included in the number, is there a formula I could use on Excel to achieve this?

TIA!!

[Andy Pope]

In A2 you could use

="E"&TEXT(((ROW()-2)*PagesPerPad)+PadStartNumber,"\E0")& TEXT(((ROW()-1)*PagesPerPad)+PadStartNumber-1," \- \E0")

Where PadStartNumber is a named cell containing 123100. And PagesPerPad is a named cell containing 30.

[martindwilson]

="e"&text(0+rows($1:2)*30-30,"000000")&"-"&"e"&text(0+rows($1:2)*30-30,"000029")

[gak67]

Check out the attached. Sheet1 uses a formula to extract the number portion and add the right number to it and put an E back in front of it. Sheet2 used just numbers, but with a formatting that appears to put an E in front of the number.
Number Range Including Letter.xlsx

[martindwilson]

gak67 try that with a number like 000030

[gak67]

Agreed, Sheet1 formulas need adjusting, assuming the OP wants/needs the format to be E000030 rather than E30, but if that assumption is true Sheet2 would still work as required.

[gak67]

Sheet1 now corrected for the issue martindwilson pointed out.
Number Range Including Letter.xlsx

[RecordTechCJ]

Thank you so much gak67(Glenn), martindwilson (Martin), and Andy Pope for replying! Glenn the spreadsheet you provided works perfectly and even though I'm not the greatest at reading and writing code I'm able to go through and make changes effortlessly! This will definitely help elevate our office into the modern times

Thanks again guys!