Continuing number/letters in great amounts

[craigwojo]

I believe there is a simple solution for this... I have a cell with data for E351 and need it to count up to E750 in the column. Instead of dragging down the cell containing E351 to E750, is there a way or shortcut just to put in the last input data to make the string of cells that need to be made?

Thank you and God bless,
Craig

 

[saboh12617]

Hello,

I'm not sure to understand.
If you want to repeat the value in cell E351 to cells E352 to E750, you can use the SEQUENCE function like so:

=SEQUENCE(750-351,,E351,0)

You can modify the last argument (0) to change the increment (assuming you're working with numbers).

 

[Scott Huish]

Is this what you need?
="E"&SEQUENCE(400,1,351)

Change the last number in the formula to the value you want to start with