Sheet List with incrementing number and letter

[MarkusEng1998]

I need to create a list of Architectural Sheet names based on a variable in an Excel form.

I map this variable to the field [Value]

I am able to create the desired number of rows (one for each sheet) using a custom column list, and expanding the list to rows.

     = Table.AddColumn(#"Renamed Columns", "SheetCount", each {1..[Value]})

From this I am able to create a sheet list, e.g.

So far so good.

   Isolated Plan Views - 1

   Isolated Plan Views - 2

   Isolated Plan Views - 3

   Isolated Plan Views - 4

But I would also like it to increment by letter too. The new sheet name would be:

   Isolated Plan Views A - 1

   Isolated Plan Views B - 2

   Isolated Plan Views C - 3

   Isolated Plan Views D - 4

I created a second custom column list:    

     = Table.AddColumn(#"Renamed Columns", "SheetCount", each {"A.."D"})

but this created 16 rows, not the desired 4. Furthermore, since [Value] may vary, the above custom column assumes a static number of characters.

Please advise.

Thanks!

[MarkusEng1998 · Accepted solution]

I figured it out.

I created another column using the ASCII value for the letter.

= Table.AddColumn(#"Added Conditional Column", "ASCII", each Character.FromNumber([SheetCount] + 64))