Excel Guides

Converting Numbers to Strings in Excel

Converting numbers to strings in Excel is a relatively simple process. There are a few different ways to go about doing this, and the method you choose will likely depend on the specific situation in which you find yourself. For example, if you need to convert a column of numbers to strings, you might use the Text to Columns command. On the other hand, if you need to convert only a few numbers to strings, you can use the CONVERT function. Let's take a closer look at both of these methods.

Using the Text to Columns Command

If you need to convert an entire column of numbers to strings, the Text to Columns command is probably your best bet. This command can be found under the Data tab on the Excel ribbon. Once you've selected your data range and clicked on the Text to Columns button, you'll be presented with a few different options for how your data should be split up. For our purposes, we're interested in the Delimited option.

Once you select the Delimited option and click Next, you'll be given a list of different delimiters that Excel can use to split up your data. Since we're dealing with numbers, we want to make sure that none of these delimiters are selected. Once you've deselected all of the delimiters, click Finish. Your data should now be converted to strings!

Using the CONVERT Function

If you only need to convert a few numbers to strings, using the CONVERT function might be a better option. This function takes two arguments: the value that you want to convert and the desired output format. In our case, we want to convert a number to a string, so we'll use the following syntax:

=CONVERT(value, "string")

Example: =CONVERT(A1, "string")


Description:
  • The value (in our example, cell A1 ) is the number that you want to convert.
  • The word "string " in quotation marks tells Excel that we want to output a string.


Note:
  • The CONVERT function will only work if your regional settings are set to English (United States). If they are not, you can change them by going to File > Options > Advanced > Editing Options > Use System Separators.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.