MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel
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 9: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 9:16 pm
Text to columns tool.
EDIT - too slow!
Posted : 06/04/2015 9:17 pm
Or just find and replace " *" with blank. Deletes everything including the space.
Posted : 06/04/2015 9:24 pm
Topic starter
cheers, done!
Posted : 06/04/2015 9:33 pm
