Results 1 to 6 of 6

If cell has x turn into number and concatenate

Threaded View

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,043

    If cell has x turn into number and concatenate

    Example is in the attch:

    Book11.xls

    This formula works but if there is no number 4 then I don't want comma after 1, or 2, or 3,

    How avoid it:

    results

    1,2,3,4
    1,2,
    1,2,3,
    3,4
    1,
    4
    2,3,

    (red , need to be removed)
    Last edited by zbor; 07-04-2009 at 07:28 AM.
    Never use Merged Cells in Excel

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