Calc - create alpha-numeric series

geoffL · February 1, 2020, 11:00am

How do I create an alpha-numeric series.
For example, if I have M11 in row 21 then I want M12 to be inserted automatically in row 22.

I know how to create a numeric series using the formula =ROW(A1)

anon73440385 · February 1, 2020, 2:56pm

Hello,

If you require a formula: ="M" & ROW()-10 to start your series in row 21 with M11 and copy down.
If you need fixed values: Write M11 into the cell and drag down on the small square in the right lower corner of the cell to the row, where you want your series to be finished (The number gets auto-incremented)

Tested using LibreOffice:

Version: 6.4.0.3, Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

geoffL · February 1, 2020, 4:57pm

Many thanks for this Answer – problem solved.

anon73440385 · February 3, 2020, 10:28am

Many thanks for this Answer – problem solved.

Aha - and why did you remove the check mark () if it helped you once?

geoffL · February 6, 2020, 4:08pm

I did not intend to REMOVE the check mark ().

erAck · February 5, 2020, 12:36pm

If it doesn’t have to be a formula then just enter M11 in a cell and pull the bottom right cell border handle down, which creates M12, M13, …