Forum Discussion

Dusandza's avatar
Dusandza
Copper Contributor
May 19, 2022
Solved

Fill series with change of second group of numbers

Hi,

I need to fill series quick in single cell:

values start with 70P 01 01, 70P 02 01, 70P 03 01 till 70P 57 01. Only second group of numbers to increase.

But when i drag first three columns Excel just increases third group of numbers 70P 01 01, 70P 01 02, 70P 01 03... 

 

is there a way so i dont have to manualy change till 57 ?

(office 365)

 

Resources