# How to recognise text with " in it

1. ## How to recognise text with " in it

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??

2. ## Re: How to recognise text with " in it

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?

3. ## Re: How to recognise text with " in it

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.

4. ## Re: How to recognise text with " in it

Try

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

5. ## Re: How to recognise text with " in it

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.

6. ## Re: How to recognise text with " in it

Originally Posted by Root_
Try

=IF(D5="3/4"" WOOD",0.750)
That got it! Thanks for the help guys!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1