how to split text in excel?
by Ramya[ Edit ] 2009-10-12 10:57:50
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".