+ Reply to Thread
Results 1 to 3 of 3

Split number data

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Split number data

    Hi All,

    If I have information like these all in one cell, is there anything to split them up so that they will be in different cell?

    Ex:
    03:00 9730.8 457.6 8378.0 .3657 -> cell A1=03:00 B1=9730.8 C1=457.6 D1=8378.0 E1=.3657

    Thanks,
    VBisgreat

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Split number data

    Sure:
    click the Data tab and select text to columns.
    choose space as your delimiter.

  3. #3
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: Split number data

    Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1