How do I separate text in a cell?
- 1 Answers
- 759 Views
- I also Faced
- E-Mail Answers
How do I separate text in a cell?..
Answer / Amlish Kumar
You can use the TEXTTOCOLUMNS function in Excel to separate text in a single cell into multiple columns based on a delimiter. For example, if your data is separated by commas and you want to put each word in a separate column, you would type '=TEXTTOCOLUMNS(A1,",")'.
| Is This Answer Correct ? | 0 Yes | 0 No |
More MS Excel Microsoft Interview Questions
How do I add toolbars in excel 2016?
How do I round up in excel?
How do I find first name in excel?
How do you use the char function in excel?
Is excel considered a database?
Where is countif function in excel?
How do I write vertically in excel?
What is ifna formula?
Which is the latest version of ms excel?
How do I get cells to add up in excel?
How do you get excel to add?
How do you convert a formula to a value?
MS Excel Microsoft 
