General discussion

Locked

need help in excel

By pkarunakar1 ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Use Text To Columns Method

by clickripplesolutions In reply to need help in excel

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.

Collapse -

Another solution...

by ianr In reply to need help in excel

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.

Back to Microsoft Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums