This question already has an answer here:
- Excel extract substring from string 5 answers
Looking at the image below I want to extract the Lats and Longs from the "geohash,latitude,longitude" column.
I can't just use the function
RIGHT(C2,LEN(C2)-8) because the Lats & Longs are different lengths and I'll have to go through the entire column E manually adding any numbers that have been removed.