Separate Numbers after a symbol

Originally published at: How to Separate Numbers after a symbol in Excel - Excelbuddy.com

This quick tutorial will demonstrate how to separate numbers after a symbol in Excel. In our example, we have a list of Serial numbers that were exported into an Excel file. By default, the serial numbers are formatted like “Serial#S988611.” Clearly, this format is no ideal to be used in an Excel sheet. Therefore, we…