How to recognise text with " in it

**hunter122976** · 08-14-2019, 02:56 PM

I'm trying to use an if function to pull info from one cell and equal another name per se in another cell. I think the problem is, I'm already using a quotation mark, so it's not reading the function correctly. .

I'm wanting to take the data that is in cell D5, (3/4" WOOD) and output 0.750.

My formula is as follows.

=IF(D5="3/4" WOOD",0.750)

Is there anyway to make excel ignore the " behind the 3/4??

Thanks in advance.

**FDibbins** · 08-14-2019, 03:10 PM

Hi, welcome to the forum

(I changed your title to something more descriptive of your question, btw)

Would you have only that instance if the text, or could you also have something like 1/4 " wood etc?
Would it be feasible to just extract the 3/4 and convert it to numeric?

**hunter122976** · 08-14-2019, 03:21 PM

Thank you very much!

Yes, there would be other instances like 1/4" wood, 7/8" wood, etc. I know it has to be the " that's getting me, but I can't find a way around it.

**Root_** · 08-14-2019, 03:22 PM

Try

=IF(D5="3/4"" WOOD",0.750)

**Sam Capricci** · 08-14-2019, 03:24 PM

I did it with something like this =IF(LEFT(D5,3)="3/4",0.75,"") but that would require either a list of lookups or individually doing each.

using a vlookup against a table it would look like this... =VLOOKUP(LEFT(D5,4),E1:F10,2,FALSE)
where the table of 3/4" in E1 and 0.75 is in F1 and others are in additional rows.

EDIT2: AND you have to have the inch indicator in the cell otherwise excel might change the 3/4 to a date.