In this publication titled convert text to number in excel using formula, I have provided a complete image from start to finish ,Please look below
