Hello everyone,

I wonder if this is possible, cell A1 contains the text "P0001", cell A2 contains "P0021", A3 contains "P0041" and so on until "P0581". The values are separated by 20 units.

If the cell is numeric, I could just make the formula on A2 as "+A1+20" and copy it down. This will give me the result from cell A2 21, 41, etc.

Is there a way to make a formula or something so that I can have "P0001", then "P0021" and so on, on a single column.