Oxeagle
2nd Nov 2006, 10:42
Hi guys,
I'm currently building a macro to update a spreadsheet with data from another spreadsheet whenever it is opened by the user. This in itself is not a problem, but part of what I would like the macro to do is to automatically break down coordinates in the format 'N51 50.22' from one cell and split it over 4 cells in the format 'N 51 50 22'. So far, I havn't been able find a forumla to do this automatically, the only way i've found is to select the 'Text to Columns' function from the 'Data' menu in Excel. Does anyone have any idea how I can do this automatically?
Thanks,
Ox
I'm currently building a macro to update a spreadsheet with data from another spreadsheet whenever it is opened by the user. This in itself is not a problem, but part of what I would like the macro to do is to automatically break down coordinates in the format 'N51 50.22' from one cell and split it over 4 cells in the format 'N 51 50 22'. So far, I havn't been able find a forumla to do this automatically, the only way i've found is to select the 'Text to Columns' function from the 'Data' menu in Excel. Does anyone have any idea how I can do this automatically?
Thanks,
Ox