I see a formula for Mid function like this:
=MID(E2,6,10^3)
And here are results:
2024W45 -> 45
2024W47 -> 47
2024W46- > 46
2025W2 -> 2
Can someone help to explain me what is “10^3” in this case? This is the first your texttime i’ve seen that.
I just see that formula on a facebook page about excel. I tried to search on google with keyword like “advanced mid function”, “mid function with “^”” but i couldn’t find anything about it.
1