Only do formula if cell contains something

[LondonEddie]

Hi there,

I've got the following forumla which is working fine, however I want to be able to copy it all the way down the worksheet, but only populate the cell it's in if cell C7 has something in it, i.e. not blank so that it doesn't look untidy, is this possible?

=IFERROR(CONCATENATE(C2,B7,D2,C7),"")

Thanks,
Eddie.

 

[jasonb75]

You could also get rid of the http:// first and then append it, then either way it will work:

=IF(C9="","","http://"&SUBSTITUTE(B9,"http://","")&$B$5&C9)

isn't that the same as my original suggestion in #6?

 

[Scott Huish]

No, you are creating 2 possible occurances of http:// and then getting rid of the second one, I am getting rid of the http:// in the first place and then adding it.

 

[jasonb75]

No, you are creating 2 possible occurances of http:// and then getting rid of the second one, I am getting rid of the http:// in the first place and then adding it.

I think you're looking at #8 not #6, wan't sure if you had something I missed and a typo made it look the same as my original.

 

[Scott Huish]

Yep, you're right. Sorry.