Results 1 to 5 of 5

CONCATENATE #'s with a twist: #~#~# /or/ #~# /or/ #

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2008
    Posts
    14

    CONCATENATE #'s with a twist: #~#~# /or/ #~# /or/ #

    CONCATENATE #'s with a twist

    I'm doing a database import of a CSV file, but before I do, I need to re-translate three columns of data into one in the following format;

    1~2~3

    I can't just simply Concatenate with "~" because some concatenations will have 1, 2 or all 3 fields to concatenate. Which means, if I only have a number in the first column; I get 1~~. other combos give me ~~3, 2~, so on. I need a formula that will only give me an output like this.

    1
    1~2
    1~2~3
    2~3
    2
    3

    Here's my very bad attempt;
    =IF(ISBLANK(D10:F10),"",CONCATENATE(D10&"~"&E10&"~"&F10))

    Excel Snap shot of desired output enclosed (output.gif) anyone got any ideas?
    Attached Images Attached Images
    Last edited by sc0tt; 06-12-2008 at 06:04 PM.

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