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 ...

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent. Dennis O'Reilly Former ...