Topic starter
Have a huge list of distances that are imported (from a GPS) as text. how can i change them to numbers?
also, the list had merged cells so the datat is in cell A1, then A3, then A5 etc, how can I paste it into C1, C2, C3, etc so that it's sequential?
(text) data looks like,
85 mÂ
148 mÂ
340 mÂ
943 mÂ
370 mÂ
388 mÂ
76.2 mÂ
89 mÂ
106 mÂ
with always a space and 'm' after it.
Ta C
Posted : 06/04/2015 10:13 pm
Data toolbar. Text to columns tool. Use space as delimiter.
Then filter, selecting non-blank cells, copy to another sheet.
Posted : 06/04/2015 10:16 pm
Text to columns tool.
EDIT - too slow!
Posted : 06/04/2015 10:17 pm
Or just find and replace " *" with blank. Deletes everything including the space.
Posted : 06/04/2015 10:24 pm
Topic starter
cheers, done!
Posted : 06/04/2015 10:33 pm
