In your Excel workbooks the data is not always structured according to your needs.

How to use the text to columns function in excel. Select Range of Cells. Columns to text with a function The CONCAT function formerly CONCATENATE will merge multiple cells into a single one. With the Text to Columns.

The Excel COLUMN function returns the column number for a reference. Select the entire sample data range B2B12. Choose Delimited and click Next.

Select the range with full names. For this we just have to select the. Text to Columns in Excel is a method which is used to separate a text in different columns based on some delimited or any fixed width there are two options to use text to columns in excel one is by using a delimiter where we provide delimiter as an input such as comma space or hyphen or we can use fixed defined width to separate a text in the adjacent columns.

Choose the Delimited option. Click on the Comma button then the next button. COLUMN takes just one argument called reference which can be empty a cell reference or a range.

To find Text To Column function on the Ribbon youd need to press Alt key first to access the Ribbon then A for Data and then E. For example COLUMNC5 returns 3 since C is the third column in the spreadsheet. Clear all the check boxes under Delimiters except for the Comma and Space check box.

Excel will open Convert Text To Columns Wizard window and automatically separate the information into columns. With the Text to Columns. The COLUMN function returns the column number of a reference.