Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
how to put quotation mark in each cell of the column | Excel Worksheet Functions | |||
Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel | |||
how do I concatenate text that has a quotation mark | Excel Discussion (Misc queries) |