Alright, hopefully this works! I've attached a Sample Workbook with before and after sheets. The before sheet I've imported from Word and the after sheet I've imported from Notepad. The text in both the Word and Notepad documents looks like:
5 cups "white flour"
"1 1/2" tsp salt
For some reason Excel imports Word docs differently from Notepad even though they're both saved as txt files. I really prefer using Word and hope I can find a solution.
Thank you for your time and help!
Bookmarks