Adding Text to Beginning of the Cell if not Blank - Then Combining Cells

[maemaemae]

Hello,

I have exported some product image urls in an excel sheet. The issue is that the urls are partial & do not contain the beginning of the url. I used the concatenate function to fix them, but the formula is applied when the cell is blank. I also want to combine all the urls in one cell separated by commas & I can't figure out how. Here's a sample of what I'm looking for.
sample2.xlsx

[maemaemae]

Bump! Any help would be much appreciated.

[Tanujkumar88]

Hi,


If you have only 3 column as mention in sample excel then use given below formula . Hope this help you.

Formula

=IF(ISBLANK(A1),"","mysite.com/"&A1)&IF(ISBLANK(B1),"",", mysite.com/"&B1&IF(ISBLANK(C1),"",", mysite.com/"&C1))


Thanks
Tanuj

[maemaemae]

Hi,


If you have only 3 column as mention in sample excel then use given below formula . Hope this help you.

Formula

=IF(ISBLANK(A1),"","mysite.com/"&A1)&IF(ISBLANK(B1),"",", mysite.com/"&B1&IF(ISBLANK(C1),"",", mysite.com/"&C1))


Thanks
Tanuj

This worked perfectly, thank you!