Discussion Locked

need help in excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ashworth Neil08-12-2013STD, I wan to take the Name alone from the text for e.g Ashworth Neil.... please can anyone provide the formula

2 replies

by clickripplesolutions

Select the particular cell you want to split, goto "Text-to-columns" under "Data" menu. Choose "Fixed Width" separator option. You can use this for any number of cells at once.

by ianr1

Copy the cells you want to break up into a text file, then import the file using space and 0 as your delimiters, take cells you need back into your original Excel file.

This discussion is closed to new replies.