Convert text to column in excel



Suppose you have sentences that contain too many words. You need to convert this into the column
"Red blue orange black" this is your sentences in one word and you have given a task to convert this into separate columns
yes, its possible in excel and this features is already given by the excel in data tab its easy just you need to convert text to the column with existing features

Convert text to column in excel


To convert text to column

1. Click on the data tab
Convert text to column in excel

2. click on the text to column
Convert text to column in excel

3. click next
Convert text to column in excel

Convert text to column in excel

4 click on finish
Convert text to column in excel


if you want to convert any into the column you can click on arrow on between the word sentence and anything in the
Now you can get your text into the column. Hope this will help you to learn excel in. if you have any query please comment or email to me

0 Comments