Results 1 to 5 of 5

Delimit string to columns after using TRIM?

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    15

    Delimit string to columns after using TRIM?

    Okay, so I have a row of data with lots of spaces between characters, simple to use TRIM to remove all but 1 space between each 'column' in the cell. Can I use an array formula or macro to transfer each 'column' of data within that cell to an actual column?

    Example:

    92,481      4,466      4,436     18,454     20,113        896     17,399    102,362     10,318      9,810      1,316        538     28,788     38,674
    Gets TRIM'd down to:

    92,481 4,466 4,436 18,454 20,113 896 17,399 102,362 10,318 9,810 1,316 538 28,788 38,674
    With spaces in between. I can't use LEFT/MID because if say, the first 'column' changes to 101,451 upon data refresh I will lose characters.

    Basically I want to take the TRIM version and convert to columns automatically


    Column1        Column2
    92,481          4,466
    ....etc
    Last edited by peepingtom; 04-27-2013 at 08:05 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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