1. Adding Text Columns In Excel
2. Excel Text To Columns Function
3. Combine Text In Columns Excel
4. Split Column Text In Excel

Related Articles

• 1 Divide Two Numbers in One Cell for Microsoft Excel
• 2 Remove CSV Formatting From a File
• 3 Import a CSV File to OpenOffice
• 4 Repeating Rows in Excel

If you don't want the default format, choose a format such as Text, then click the second column of data in the Data preview window, and click the same format again. Repeat this for all of the columns in the preview window.

If you have data in delimited text files from other programs that you need to get into an Excel workbook, you can use the import wizard to import delimited text files and convert them into usable spreadsheet data cells. However, if you are copying delimited text directly from a source that can’t be imported using the wizard—such as a website or non-delimited document that contains delimited data—you’ll need to use the Text to Columns feature to convert the data into Excel cells.

Select the delimited text and copy it to the clipboard.

Click the first cell in column A and click the “Paste” button in the ribbon. The delimited text will be copied to the workbook’s first column in text format.

Click the column A header to select the entire column. Click the Data tab on the ribbon and then click Text to Columns. The Convert Text to Columns Wizard window will appear.

Adding Text Columns In Excel

Leave the Delimited option checked and click “Next.”

Select the delimiter from the list of options provided. For example, if the data is separated by commas, check Comma from the list. You can also enter a custom delimiter in the Other box or select multiple delimiters. Review the preview panel at the bottom of the wizard window and click “Next” when you are satisfied with the data import.

Select a data type from the Column Data Format section. Click the second column and select a data type for that column. Repeat for every column you are importing into the workbook. You can also opt to exclude a specific column by checking the Do Not Import Column (Skip) option.

Click “Finish” when you are satisfied with the data types. The delimited text will be formatted into separate columns and assigned data types based on your selections.

Excel Text To Columns Function

Tip

• If some entries in the delimited data set are blank, check the Treat Consecutive Delimiters as One option in Step 6 to place blank data in the correct cell.

About the Author

Jacob Michael has been a freelance writer since 2010, with expertise in computers, cooking, travel and other topics. He holds a bachelor's degree in English from the University of Hawaii at Manoa and is pursuing a master's degree in American studies.

Choose Citation Style

This Excel tutorial explains how to center text across multiple cells in Excel 2016 (with screenshots and step-by-step instructions).

See solution in other versions of Excel:

Question: I want to center text across multiple cells in Microsoft Excel 2016 but I don't want to have to merge the cells. How can I do this?

Answer: Select the cells that you wish to center the text across.

Combine Text In Columns Excel

Right-click and then select 'Format Cells' from the popup menu.

When the Format Cells window appears, select the Alignment tab. Click on 'Center Across Selection' in the drop-down box called Horizontal.

Split Column Text In Excel

Now when you return to your spreadsheet, you should see the text centered across the cells that you selected.