TEXT TO COLUMNS EXCEL FUNCTION - THE ULTIMATE GUIDE

2 years ago
18

There are times when you need to export data from an application or software to Excel. The data appears to be continuous, and you want to separate it into different columns. You will need the Text to Columns function for this.

Text to Columns in Excel is a method used to separate a text into different columns. There are two options to use Text to Columns in Excel:
1. Delimited which is good if there is a common character like tab, semicolon, comma, space or other characters that can be used to separate the texts.
2. Fixed Width which is ideal if the fields of your data are aligned in columns.

You can quickly show the Text to Columns window with a keyboard shortcut. Watch this video to learn about it.

TITLE: TEXT TO COLUMNS EXCEL FUNCTION - THE ULTIMATE GUIDE

#texttocolumns #exceltutorial #howtodotexttocolumnsinexcel #keyboardshortcut

Loading comments...