So so helpful! At first it was giving me trouble because the data I was trying to convert had several spaces after the textual data, so I was not inputting the exact textual data to convert it to the number I wanted... therefore it was saying it could not find the textual data I wanted to convert. What helped is I copied and pasted the cell exactly how it was into the "find what" box in the replace tab and it worked! I just couldn't see the spaces after the text
Girl, you are a lifesaver!!! This video was very helpful until I realized I had the same problem as you. So I was like okay, never mind, after seeing so many videos I cannot actually use this either so back to the crying (just kidding..or am I? :D) BUT your comment just saved me an enormous amount of time! You have no idea how happy and relieved I am right now. Really, thank you so much for taking the time to write this comment! Have a nice day :)