HomeMicrosoft OfficeExcelHow to Separate Strings in Excel?

How to Separate Strings in Excel?

Here’s an article that helps you to understand strings in Excel and show how to separate strings in Excel?

How to Separate Strings in Excel?

Follow the steps mentioned below to Separate Strings in Excel.

  • First, prepare an excel sheet with the required details in it.
How to Separate Strings in Excel?
  • Select the column that you want to separate.
  • Now click on the Data Tab, then to Text To Columns option.
How to Separate Strings in Excel?
  • Now the Convert Text to Columns Wizard option pane opens up and then select Delimited, then click the Next button.
How to Separate Strings in Excel?
  • Select the Delimiters for the data, like Comma and Space, then click the Next button.
How to Separate Strings in Excel?
  • Then select the Destination option pane, where you want the split data to appear, and then click the Finish button.
How to Separate Strings in Excel?
  • The picture below is the result for the steps mentioned above in the article.
How to Separate Strings in Excel?

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021