I have an alphanumeric field which I would like to autofill - but it only copies. Can it be done?
For example:
Value: Q2.1
I want to autofill Q2.1.a, Q2.1.b, Q2.1.c, ...
I've tried clicking and dragging with Q2.1.a and Q2.1.b highlighted but it just repeats the value (Q2.1.a, Q2.1.b, Q2.1.a, Q2.1.b,..)
When I autofill Q2.1 it increments correctly: Q2.1, Q2.2, Q2.3, ...
How can I autofill the tertiary outline level?
Any help would be appreciated!
Thanks
Bookmarks