Forum Discussion

Herfnation's avatar
Herfnation
Copper Contributor
May 15, 2019

FILL SERIES

I am sorry if this is an easy solution, but I have been having trouble figuring this out. I want to produce a series with letters and numbers. Example is 1H, 2H, 3H, 4H, ..., 90H. Not sure if I should be using a function, formula, or what. Any help would be greatly appreciated. Thanks in advance.

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 15, 2019

    Herfnation , depends on what you'd like to do with values from that series. As variant you may simply generate series of numbers from 1 to 90, Ctrl+1 on it and apply custom format General"H"

     

    Actually that will be numbers, but shown with H at the end.

Resources