Header Ads

How to Use Text to columns in Excel

           TEXT TO COLUMNS IN EXCEL



Step 01:  We can find text to columns in data tab(data tools)


Step 02: Click through the text to columns




Step 03: Go with delimited to split words




Step 04:  Go the fixed width, we can specify the comma, space, tab





Step 05: We can split the words in a cell by using these two methods

No comments

Powered by Blogger.