+ Reply to Thread
Results 1 to 10 of 10

Need Micros to splitte Data with a column that is separated by tilde sign

  1. #1
    Registered User
    Join Date
    06-07-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Need Micros to splitte Data with a column that is separated by tilde sign

    Test.xlsxTest.xlsx

    HI All

    I have an excel spread sheet that has twelve columns in it with data, the column that is in question is column F. I get an extraction for client with Barcode numbers that are split by the tilde sign (~) (Example below)

    116588389~116577483~116269219~115475917~114679467~118346616~119220663~119221596~

    I would like to run a micros that will take all these number in all the rows and put them in one column (A) right underneath each other. (Example below)

    116588389
    116577483
    116269219
    115475917
    114679467
    118346616
    119220663
    119221596

    Thank you for your help.
    Last edited by Oszie; 07-31-2013 at 04:26 AM. Reason: spelling

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,761

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    06-07-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    HI Sixthsense


    Done

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,761

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    Try this...

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-07-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    It does split the tilde signs but it puts it in the same sheet and overwrites column A?

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,761

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    No it won't do like that... since the code create a new sheet and populate the results. Please check...

  7. #7
    Registered User
    Join Date
    06-07-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    HI

    its still doing it, checked, and double checked, its fine, I can use it like this.

    Thank you very much.

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,761

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    Try this revised code....

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-07-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    That's the one, thank you. Work fine now.

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,761

    Re: Need Micros to splitte Data with a column that is separated by tilde sign

    Glad it helps you and thanks for the feedback

+ 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. [SOLVED] Need a good Micros for splitting data into new sheets.
    By Oszie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2013, 06:43 AM
  2. Merge rows with different column of data into one row separated by a empty row
    By phuu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2012, 10:48 AM
  3. Replies: 2
    Last Post: 02-02-2012, 09:02 AM
  4. Replies: 1
    Last Post: 09-07-2006, 04:28 PM
  5. Separated data in one column to multiple columns
    By leenathan@gmail.com in forum Excel General
    Replies: 2
    Last Post: 06-30-2006, 04:10 PM

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