Excel 'Text to Columns' question
Thread Starter
Joined: Feb 2006
Posts: 216
Likes: 0
From: Here and there
Excel 'Text to Columns' question
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
That set me off in the right direction, looked up the text manipulation formulae that you mentioned and voila! It works flawlessly now.