Forum Discussion
Dusandza
May 19, 2022Copper Contributor
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)
2 Replies
- OliverScheurichGold Contributor
- DusandzaCopper Contributorworks like a charm. thank you!