If(AND formula with values using foot and inch designations (' ")

Good morning!
I am trying to write what should be a simple formula but am drawing a blank. I am doing if(and against two cells, one of which contains ' and " as part of the text
My formula will look like this, but will be built on with more options

Please Login or Register  to view this content.

B106 is a pull-down menu with 2 possibilities. either 1'0" to 2'4" x 6'8" or 2'6" to 3'0" x 6'8". I know the problem is in the ' and " designations but I can't for the life of me remember how to get around this without rewriting several hundred descriptions using inches and feet in place of " and '. Google has been of no help, and I have searched several forums as well.
I am most appreciative of any suggestions or assistance,
Thanks much
Bill

Please use Char(34) for double quote

=IF(AND(B106="1'0"&CHAR(34)&" to 2'4"&CHAR(34)&" x 6'8"&CHAR(34)&" or 2'6"&CHAR(34)&" to 3'0"&CHAR(34)&" x 6'8"&CHAR(34),B107="Hollow Core"),118.18)