Separate Text Contract For Free

Click the ?Data? tab in the ribbon, then look in the "Data Tools" group and click "Text to Columns." The "Convert Text to Columns Wizard" will appear. In step 1 of the wizard, choose ?Delimited? > Click [Next]. A delimiter is the symbol or space which separates the data you wish to split.

1st method In the first empty column, write =SPLIT(B1,"-") (or =TEXTSPLIT(B1,"-") in Excel), with B1 being the cell you want to split and - the character you want the cell to split on. (If you see the error #REF! in your cell, you'll need to create more columns.)

On the Data tab, in the Data Tools group, click Text to Columns. The Convert Text to Columns Wizard opens. Choose Delimited if it is not already selected, and then click Next. Select the delimiter or delimiters to define the places where you want to split the cell content.

Try it! Select the cell or column that contains the text you want to split. Select Data > Text to Columns. In the Convert Text to Columns Wizard, select Delimited > Next. Select the Delimiters for your data. ... Select Next. Select the Destination in your worksheet which is where you want the split data to appear.

Text to Columns Command to Split Text Select the entire sample data range (B2:B12). Click on the Data tab in the Excel ribbon. Click on the Text to Columns icon in the Data Tools group of the Excel ribbon and a wizard will appear to help you set up how the text will be split. Select Delimited on the option buttons.

Select the cells you want to divide, navigate to the Data tab > Data Tools group, and click the Text to Columns button.

How to split cells into columns in Excel using the Text to Columns Wizard Select your cells. Click on the cell you want to split. ... Navigate to the Convert Text to Columns Wizard. ... Choose the "Delimited" option. ... Adjust your delimiter settings. ... Input formatting information. ... Finish and review your new columns.