How do I split text in an excel cell?
- 1 Answers
- 776 Views
- I also Faced
- E-Mail Answers
Answer / Rishu Kumar
To split text into separate cells or rows within a single cell in Excel, you can use the LEFT, MID, RIGHT, and FIND functions. One common method is to use the combination of LEFT and FIND functions: Place the text you want to split in the first cell, select an empty adjacent cell, enter `=LEFT([text_cell], FIND(" ",[text_cell],1) - 1)` and drag the formula down or across to copy it for the remaining parts. This will split the text at each space character.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I increase font size in excel drop down list?
What is advantage of ms excel?
How do you copy table from excel to word and keep formatting?
What is xlookup?
What are the major differences between a spreadsheet and a database?
How do I restrict a response in excel?
What is the importance of pivot table?
What do you mean by spreadsheet?
What is the difference between vlookup and lookup?
What are values in excel?
How do you calculate 20% in excel?
How do I change the default font in microsoft excel?
MS Excel Microsoft 
