Home

FILL SERIES

%3CLINGO-SUB%20id%3D%22lingo-sub-571287%22%20slang%3D%22en-US%22%3EFILL%20SERIES%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571287%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20sorry%20if%20this%20is%20an%20easy%20solution%2C%20but%20I%20have%20been%20having%20trouble%20figuring%20this%20out.%20I%20want%20to%20produce%20a%20series%20with%20letters%20and%20numbers.%20Example%20is%201H%2C%202H%2C%203H%2C%204H%2C%20...%2C%2090H.%20Not%20sure%20if%20I%20should%20be%20using%20a%20function%2C%20formula%2C%20or%20what.%20Any%20help%20would%20be%20greatly%20appreciated.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-571287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-571300%22%20slang%3D%22en-US%22%3ERe%3A%20FILL%20SERIES%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F342730%22%20target%3D%22_blank%22%3E%40Herfnation%3C%2FA%3E%26nbsp%3B%2C%20depends%20on%20what%20you'd%20like%20to%20do%20with%20values%20from%20that%20series.%20As%20variant%20you%20may%20simply%20generate%20series%20of%20numbers%20from%201%20to%2090%2C%20Ctrl%2B1%20on%20it%20and%20apply%20custom%20format%20General%22H%22%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActually%20that%20will%20be%20numbers%2C%20but%20shown%20with%20H%20at%20the%20end.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-571447%22%20slang%3D%22en-US%22%3ERe%3A%20FILL%20SERIES%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-571447%22%20slang%3D%22en-US%22%3EThanks%3C%2FLINGO-BODY%3E
Herfnation
New Contributor

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.

2 Replies

@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.

Thanks