+ Reply to Thread
Results 1 to 2 of 2

Converting Text String to Separate Numbers

  1. #1
    Registered User
    Join Date
    06-07-2006
    Posts
    23

    Converting Text String to Separate Numbers

    I copied some information from a website directly into Excel. However, all the numbers are included in one cell as a text string. How do I get each data element into a separate field in Excel and do this so the numbers are recognized as number. Examples of the text strings are listed below:
    Sep11 393 DENVER -4.5 -6 -5 -6 -4 -6
    01:00 394 MIAMI 38.5 37 38.5 37 37

  2. #2
    Forum Contributor
    Join Date
    05-14-2006
    Posts
    104

    text in one cell

    try click on the cell and then click on DATA TEXT TO COLUMNS then you have two choices Delimited wher spaces or commas or / marks will serperate the text into cells or you have the option of fixed with wher you can move the vertical lines to split the cell

+ 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