Forum Discussion
Report year from a Text String.
Hi, novice user here, I am not a power user and do not know all the functions available. I am sure this is a very basic function but do not know where to start. Is there a function within exc...
Let's say you have such a value in D2.
In another cell, for example E2, enter the formula
=MID(D2, FIND(".", D2)+1, 4)
This can be filled or copied down if required.
Thank you Hans. Worked a treat! 🙂