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 ...
Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. Press Ctrl+; > Space > Ctrl+Shift+; ...
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 ...