Excel formulas

I have a spreadsheet in Excel 2007 which shows in column A a person's forename. In column C is the forename of their spouse\partner if they have one. Column D is their surname.

I want to insert in column B an ampersand (&) if there is a name in column C but to leave it blank if there is no spouse\partner name in column C. So we should then see John (column A) & (column B) Jane (column C) Bull (column D).

The spreadsheet has 180 lines so I want to insert a formula in column B which will give me the result above. I have tried various IF or IS statements but without success.

Hope that someone has the answer.

 

Hi Plodr,

I have now found out the formula which is b =IF(C1="","","&").

Thanks for your interest.

 

IF(ISNULL[COLUMN B],COLUMN A & " " COLUMN B, COLUMN A & " " "&" COLUMN B & " " COLUMN C)

You needed to find the ISNULL and give it a if true result and a if false result.

I can't verify this formula my excel is broken work with it the commas are important. tip click the column cell instead of typing it

 

Is that the whole forumla? I think it makes no sense in relation to your requirement. I believe jewlzs is on the right track. Can you follow the logic of his formula?