instr returns 0 always

[rhayes1010]

I have a couple of issues.

One of my cells has "53°38′44″N" in it.
When I use grab the cell value I get "53°38'44?N", also tried cell text, still get the question mark.
While this is not a big problem, I can work around this.

I'm attempting to convert the Deg.Hr.Sec to a decimal.

I'm finding my landmarks, Deg,Hr and Sec. and using the instr function to grab the numbers.

Please Login or Register  to view this content.

As you can see I can just change chr(34) to chr(63) and it's no longer an issue.

But....
hr and Sec always are 0. Instr never returns their position. Why??

very confused, how can I find these in the string?

Ron

[snb]

Please Login or Register  to view this content.

[rhayes1010]

thanks, that works nicely. I was going to do it almost the same but a little more stretched out.

Still curious though why it didn't return the values.

Ron

[rhayes1010]

on second look, the seconds returns 53 when I use the value returned from the cell. there is something in the returned value that is messing things up.

Ron

[rhayes1010]

I printed out the ascii values of each character in the string, there are no non-printable characters hidden in it.

53
51
176
51
56
39
52
52
63
78

yet if I set the string manually it work.

very confusing.

Ron