How to Convert Text in Excel

Ultimate Suite for Excel includes a feature that will be in handy if you need to convert text. You can convert numbers stored as text to number format, replace irrelevant characters and line breaks with the chars you need, and even change the accented characters to their non-accented equivalents.

Before you start

We care about your data. The add-in will back up your file if you select the corresponding option.

How to convert text

Click the Convert icon on the Ablebits Data tab in the Text group:
Convert text in Excel.
You can see the Convert Text pane:
How to convert in Excel.

  1. Select the cells where you need to convert values.
  2. Click the Expand selection icon to highlight the whole table.
  3. Sometimes numerical data in worksheets is formatted as text - it often happens when digits are imported from a database. Choose the option Convert numbers stored as text to numbers to change text to number format in any range of your choice.
  4. Your spreadsheet may contain irrelevant characters that you need to replace with new ones. Use Convert characters [...] to [...] to avoid repeating the same steps. Enter all characters you want to change individually and type the character that will replace of the unwanted ones.
  5. Pick this option to convert line breaks to the characters you need. You can choose between standard replacements for the carriage returns in your Excel cells in the drop-down list: a semicolon, a comma, a dot/full stop, or a space. Or, enter your own character(s) in the field.
  6. This option will come in handy if you need to replace the accented chars with regular ones.
  7. We recommend always ticking off the Backup the worksheet checkbox so you never lose your data.

Click the Convert button to get your result.