Hello. I am using Excel 365, version 2012, build 13530.20440.
I am trying to convert cells that contain, for example,
I am trying to convert cells that contain, for example,
3'6''
to 3-6
or 7'8.5''
to 7-8.5
. Note that the apostrophes used are both single apostrophes. I have tried using find and replace to quickly change these (there are thousands across several sheets). F&R seems to work on the single apostrophe between the two numbers, but the set after the numbers is giving me issues. I imagine it has to do with how Excel handles a single apostrophe. I want to remove the two single apostrophes altogether. I have successfully replaced them with a letter or even a word, but then cannot get the letter to be replaced with nothing. I plan on using the new format to use vlookup in another workbook so it is imparitive that the format is exactly x-x
. Also, my knowledge of VBA is nonexistent, so any solution avoiding that would be preferred. Thank you.