Answer Posted / 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 |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
