If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula For Finding a Quotation Mark In a String
I have a bunch of part numbers in Col. A formatted as Text.
Some of these part numbers include a quotation mark (") to signify diameter in inches. For instance: 1411-04-RD 1/4" Red Nylon Tubing What I want to do is write a formula that locates all those parts that have the quotation mark in their string. So, I wrote the following (which obviously does not work!!): =if(find("""",a2), do something, do something else) I think that my problem is the triple quotation marks in the formula, but I don't know how to get around it. Thanks for your suggestions. -- tb |
#2
|
|||
|
|||
Formula For Finding a Quotation Mark In a String
Try it this way:
=if(isnumber(find("""",a2)), do something, do something else) Regards, Fred "Tiziano" wrote in message ... I have a bunch of part numbers in Col. A formatted as Text. Some of these part numbers include a quotation mark (") to signify diameter in inches. For instance: 1411-04-RD 1/4" Red Nylon Tubing What I want to do is write a formula that locates all those parts that have the quotation mark in their string. So, I wrote the following (which obviously does not work!!): =if(find("""",a2), do something, do something else) I think that my problem is the triple quotation marks in the formula, but I don't know how to get around it. Thanks for your suggestions. -- tb |
#3
|
|||
|
|||
Formula For Finding a Quotation Mark In a String
This might help reduce the confusion.
Assuming it's a double quote and not 2 single quotes. =IF(COUNT(FIND(CHAR(34),A2)),"Yes","No") CHAR(34) = " (double quote) -- Biff Microsoft Excel MVP "Tiziano" wrote in message ... I have a bunch of part numbers in Col. A formatted as Text. Some of these part numbers include a quotation mark (") to signify diameter in inches. For instance: 1411-04-RD 1/4" Red Nylon Tubing What I want to do is write a formula that locates all those parts that have the quotation mark in their string. So, I wrote the following (which obviously does not work!!): =if(find("""",a2), do something, do something else) I think that my problem is the triple quotation marks in the formula, but I don't know how to get around it. Thanks for your suggestions. -- tb |
Thread Tools | |
Display Modes | |
|
|