+ Reply to Thread
Results 1 to 2 of 2

Splitting Strings

  1. #1
    Registered User
    Join Date
    08-03-2007
    Posts
    7

    Splitting Strings

    I'm Having a bit of trouble splitting strings accurately and I thought of just the people that would be able to help.

    I have examples of some strings below that I need to split.

    27/27/14
    2/2/3
    214/141/4
    217/412/2 ABC
    2/4/4 DEF

    I Need to be able to split them as following:
    27 then 27 then 14
    2 then 2 then 3
    214 then 141 then 4
    217 then 141 then 2 then abc
    2 then 4 then 4 then def

    ("Then" means different cells (hope I made it clear))

    Hope someone can help.

    Merry xmas

    Jay.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try this

    Select the column > then Data > Text to Columns > delimiter's are space and in other enter /

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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