Sometimes it's not possible to separate data yourself before putting it into an Excel spreadsheet. Often, the information from old data files gets lumped into a single cell. The same can happen if you ...

Q: I have noticed that when I use Excel’s Text to Columns tool to parse text data, sometimes it automatically recognizes the commas, spaces, quotes or other separators, and other times it does not.