Viewing 5 posts - 1 through 5 (of 5 total)
  • Excel help
  • ChrisE
    Free Member

    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

    jam-bo
    Full Member

    Data toolbar. Text to columns tool. Use space as delimiter.

    Then filter, selecting non-blank cells, copy to another sheet.

    i_like_food
    Full Member

    Text to columns tool.

    EDIT – too slow!

    Fresh Goods Friday 696: The Middling Edition

    Fresh Goods Friday 696: The Middlin...
    Latest Singletrack Videos
    njee20
    Free Member

    Or just find and replace ” *” with blank. Deletes everything including the space.

    ChrisE
    Free Member

    cheers, done!

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘Excel help’ is closed to new replies.

Members Notice New deal added to Members Discounts