Results 1 to 4 of 4

Thread: Separate text with comma

  1. #1
    Junior Member
    Join Date
    Jun 2012
    Posts
    15
    Rep Power
    0

    Separate text with comma

    Separate text with comma down by down

    Apple-5, banana-2, Mango-12, watermelon-1, papaya-4, Grapes-12,

    to change

    Apple-5,
    banana-2,
    Mango-12,
    watermelon-1,
    papaya-4,
    Grapes-12,

    in one cell..


    Regards,

    Sanjeevi
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Sanjeevi,

    Try

    =SUBSTITUTE(D5,", ",", "&CHAR(10))

    and wrap the cell.

    HTH
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Junior Member
    Join Date
    Jun 2012
    Posts
    15
    Rep Power
    0
    code Working successfully Thank.. U bro :D

  4. #4
    Junior Member NBVC's Avatar
    Join Date
    Jun 2012
    Posts
    5
    Rep Power
    0

Similar Threads

  1. Split Workbook into Separate Workbooks VBA
    By Admin in forum Download Center
    Replies: 12
    Last Post: 08-08-2018, 09:33 PM
  2. Excel Number Format: Indian Style Comma Separation
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 09-18-2013, 11:38 AM
  3. export all worksheets to separate csv files
    By rabidfly in forum Excel Help
    Replies: 4
    Last Post: 11-18-2012, 02:11 PM
  4. Replies: 12
    Last Post: 08-19-2012, 06:17 PM
  5. Follow-up to "Excel Number Format: Indian Style Comma Separation"
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 2
    Last Post: 04-14-2012, 10:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •