I have a spreadsheet containing Area references called C1,C2,C3 etc representing different stores. I want to increase each Area by 1 so that C1 becomes C2, C2 becomes C3 etc. Is there a formula I can put in a extra column that will do this for me please?
thanks
Bookmarks