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