|
|
how to split text in excel? - MS Office
|
Views : 552
|
|
Tagged in : MS Office
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
Split text in MS Excel:
Convert text to columns by seperating the text using some delimiters like space,{,...
Spit text in Excel / Convert text to Columns in MS Excel:
* Open Excel.
* Select the cell which you to convert text to columns.
* Go to data->Text to Columns.
* Choose the option "Delimited" and "Next".
* Select the delimiters Tab, Space, Semicolon, Comma.
* If you want to use other delimiters, select "Other" and type the delimiter in the box provided.
* Click "Next" and "Finish". |
|
By Ramya, On - 2009-10-12 |
|
|
|
