View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Gord is offline
external usenet poster
 
Posts: 86
Default Split words in a cell

DataText to Columns??

Or post some examples and show where you want the split.


Gord Dibben Microsoft Excel MVP

On Thu, 11 Aug 2011 14:18:33 +0300, "Rafeek"
wrote:

I have a spreadsheet which contains a column for 'Student's full names'. I
want to split the full names which consists of 3 or 4 names combined with a
space between them. How do I do this.

Any help will be highly appreciated.