Applying Characters to Text in Cells?

[byepeeps]

HI,

I'd like to apply characters to a word or a phrase in a cell based on the content of another cell. For example:

Cell A1,2,3
word one
word two
word three

Cell B1,2,3
yes
yes
no

Cell C1,2,3
"word one"
"word two"
[word three]

As you can see, if the word in column A is next to a cell in column B that has a yes in it then it will add quote marks as shown in cells C1 and C2. If the cell in column B has a no in it then square brackets are added around the word or phrase in cell C.

Is this possible and if so how?

Thanks,
Alex

[Andy Pope]

=if(upper(b1)="yes",char(34)&a1&char(34),"["&a1&"]")

[byepeeps]

=if(upper(b1)="yes",char(34)&a1&char(34),"["&a1&"]")

Thank you so much that works a treat. I've added to your reputation if that is any use to you