OK, I figured out a workaround. It's a PITA though. I find and replace the separators that are always before the "words" that get auto corrected with ;' (any two symbols would work I'm sure). The T2C wizard will let me choose the separator. After that I format all the new cells as text then search for ' (apostrophe) then replace it with a space. I get the columns I need with the right data and not the auto-correct.
Regardless, there needs to be an option that globally turns of this auto-correct. It may be needed for some but not all. How would I contact MS to request this in future releases?