how to split text in excel?

by Ramya 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".

Tagged in:

1659
like
0
dislike
0
mail
flag

You must LOGIN to add comments