Split words in a cell

  • Thread starter Thread starter Rafeek
  • Start date Start date
R

Rafeek

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.
 
Data>Text to Columns??

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


Gord Dibben Microsoft Excel MVP
 
Data>Text to Columns. This is what I was looking for.
Is there any commands to do the opposite? I know it can be done with
concatenate function or by joining with ampersand.

Thank you.
 
Excel has no functions to join strings from cells other than
concatenate or ampersand which you know about.

There are single step methods available using VBA, of course.


Gord
 
Thank you, Gord.


Gord said:
Excel has no functions to join strings from cells other than
concatenate or ampersand which you know about.

There are single step methods available using VBA, of course.


Gord
Click to expand...
 
Back
Top