Searching for quotes using a formula results in #VALUE! error

[jeff_cp]

Field AR10 = “6B29FC40-CA47-1067-B31D-00DD010662D1”

The formula I'm using is =SEARCH("""",AR10,1) which should result in a 1 but is resulting in #VALUE!.

I've also tried =SEARCH(CHAR(34),AR10,1) and having the same issue.

I tried removing the hyphens in AR10 but getting the same error.

I'm using this same formula throughout my spreadsheet and not having any issues at all. It's just this one field AR10.

Any help would be greatly appreciated...this one is driving me crazy!

 

[Fluff]

The string starts with “ not " which is why you get the error.
Try

=SEARCH("""",SUBSTITUTE(AR10,"“",""""),1)

 

[jeff_cp]

Geez...thanks! I just simply changed the two single quotes in field AR10 to a double quote and that got it.

 

[Fluff]

Glad to help & thanks for the feedback.