Hello, I want to extract a partial value from a cell.
The original value is composed as follow “48.593345, -123.399607”.
I have no problem to extract the left portion of the value. However I have a problem to extract dynamically the right value.
A spreadsheet with same examples is attached.
Scenario #1 - #5 are no problem.
And based and these scenarios (#1-#5) I build the formula for Scenario #6.
But for some reason, I don’t know why, it is not working as I expected.
Perhaps someone smarter as I am can explain what I am doing wrong.
Thanks for any reply.
PS. Why can’t I attach a screenshot and insert it into my posting in this forum?
Extractions.ods (17.6 KB)
