+ Reply to Thread
Results 1 to 5 of 5

Need a formula for comma seperated values with special case...

  1. #1
    Registered User
    Join Date
    11-29-2022
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2007
    Posts
    70

    Lightbulb Need a formula for comma seperated values with special case...

    I need a formula when putting into cell (b2) automatically converted to comma seperated values as such that "all zeros of that integer attach to the left non zero values and also that comma putted into between non zeros values too"...
    Like for examples:
    60606060 converted to 60,60,60,60
    450045004500 converted to 4,500,4,500,4,500
    112450230560 converted to 1,1,2,4,50,2,30,5,60
    101001000123 converted to 10,100,1000,1,2,3
    and then further these required comma seperated vaues be putted into separate cells. Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,277

    Re: Need a formula for comma seperated values with special case...

    Please Login or Register  to view this content.
    Code in worksheet: right click, "view code" and copy/paste above code

    Enter data in B2
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    11-29-2022
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2007
    Posts
    70

    Re: Need a formula for comma seperated values with special case...

    Thanks Sir, I will check it and back to you soon...

  4. #4
    Registered User
    Join Date
    11-29-2022
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2007
    Posts
    70

    Re: Need a formula for comma seperated values with special case...

    Thanks very much, My problem is solved... Great piece of Code... Appreciated...

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,277

    Re: Need a formula for comma seperated values with special case...

    You're welcome. Thank you for the feedback and rep.

+ 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. Comma Seperated Values UFT-8 Save in VBA
    By Matty5894 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2015, 12:39 PM
  2. [SOLVED] Formula to count the occurance of values seperated by a comma
    By bouncingbudha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2013, 10:23 PM
  3. Add Comma seperated values of texttbox in different cells
    By kmlprtsngh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2010, 02:03 PM
  4. Sum values in cells seperated by comma's
    By keithnrhonda in forum Excel General
    Replies: 1
    Last Post: 09-15-2010, 12:30 AM
  5. Find the sum of Comma Seperated Values In a Cell
    By xcelion in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 09:05 PM

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