Hi,
This is really bugging me. I have data in cells such as AIPM41 then HAZ03 and then IVA05 for example down a column. All I want to do is to be able numbers to the alphnumeric data for example if in cell A1 it’s AIPM41, I want to get say AIPM42 in cell A19 for example (ie: I cant just click and drag). If I do =A1+1 it gives me #Value.
Any solutions would be greatly appreciated.
Thank you,
Michael.
