+ Reply to Thread
Results 1 to 2 of 2

Separate text and numbers in excel of variable length

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    Singapore
    Posts
    1

    Separate text and numbers in excel of variable length

    i have this long data set with all the values in one column and also in some cases the last value is missing

    Data
    Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
    Panama 1991 40499 3054 21 300
    Liberia 2005 42200 3100 22

    Example last enrt is mssing in the following and speed could be in 1 decimal at times
    Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
    Liberia 2005 42200 3100 22.5

    Can anyine help in separarting out this long set of data in to individual columns

    Thanks

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning anuj.lakhanpal

    ...and welcome to the forum!!
    Quote Originally Posted by anuj.lakhanpal View Post
    Can anyine help in separarting out this long set of data in to individual columns
    Try using text to columns.
    Highlight your data and go to Data > Text to columns.
    Select delimited and click on Next.
    As your delimiter choose space and then click on next, then finish.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. separate text and numbers
    By dvandaniker in forum Excel General
    Replies: 10
    Last Post: 01-14-2009, 03:05 PM
  2. Aligning numbers when combining numbers & text
    By skerdoba in forum Excel General
    Replies: 8
    Last Post: 06-21-2008, 03:04 PM
  3. Numbers formatted as text
    By andrewc in forum Excel General
    Replies: 3
    Last Post: 05-20-2008, 09:02 AM
  4. schedule in excel with text and numbers
    By telcotech in forum Excel General
    Replies: 2
    Last Post: 11-18-2007, 01:40 PM
  5. importing a text file with negative numbers into excel?
    By jstnvndn in forum Excel General
    Replies: 1
    Last Post: 09-19-2006, 09:45 AM

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