Discover latest Indian Blogs Excel Shortcuts - Text to Columns Skip to main content

Excel Shortcuts - Text to Columns

# Little Savings

Text to Columns:

When we copy - paste something into the excel. Suppose, you copy the below text into excel.

1. User app crashed while login
2. User unable to login.

It will paste as below. 

Little Savings - Excel

If you want to separate the serial number and text, use the shortcut "Text to Columns".

Route -
Select the cells you want to segregate
Select Data tab -> Find Text to Columns.
Select the Delimited radio option
Click Next
Select the corresponding de-limiter based on your requirement
Click Finish

Little Savings - Excel

Little Savings - Excel

This is the output after delimitng any character in a row.
Little Savings - Excel