Microsoft

General discussion

Creator

Topic
November 27, 2014 at 4:23 pm #2139577

need help in excel

Locked

by pkarunakar1 · about 10 years, 2 months ago

Tags: Microsoft

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.
Creator

Topic

All Comments

Author

Replies
- December 2, 2014 at 5:30 am #3038489
  
  Use Text To Columns Method
  
  by clickripplesolutions · about 10 years, 1 month ago
  
  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.
- December 11, 2014 at 7:37 pm #3038729
  
  Another solution…
  
  by ianr1 · about 10 years, 1 month ago
  
  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.
Author

Replies

Viewing 1 reply thread

Start a Discussion

Start New Discussion