Create a new worksheet and enter this in B2 of the new worksheet and copy down and across. This will reverse all the co-ordinates in columns B onward.
Formula:
=MID('betalingszone (1)'!B2,SEARCH(" ",'betalingszone (1)'!B2,2),LEN('betalingszone (1)'!B2)-SEARCH(" ",'betalingszone (1)'!B2,2))&" "&LEFT('betalingszone (1)'!B2,SEARCH(" ",'betalingszone (1)'!B2,2))
If column A is text that hasn't been converted to columns, use the text to columns feature so that the co-ordinates start in column B and use the following on a new worksheet.
Column A would then have this formula copied down the column:
Formula:
='betalingszone (1)'!a2
Bookmarks