Excel Magic Trick 1184

Formula to Create Alpha Numeric Series X20, X25, X39…

DESCRIPTION

See how to create formula to create Alpha Numeric Series X20, X25, X39… using ROWS function. See the ROWS function and an expandable range to create sequential numbers or incrementing numbers or formula element to increment numbers.