Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...

Splitting the contents of a cell into more than one column manually in Microsoft Excel would take too much time and likely result in errors. Fortunately, the program offers many ways—from built-in ...