Formula For Finding a Quotation Mark In a String

T

Tiziano

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inability to add quotation mark around a variable by concatenation in VBA 4
Finding the right style field in VBA 0
How to copy only the numbers that are between quotation marks in new cells 1
Writing formula to include quote marks in result 4
how to put quotation mark in each cell of the column 17
Finding a specific text in a cell 2
Put a single quotation mark in front of numbers in selected cells 4
Single Quotation mark in CSV 1

Top