Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split words in a cell
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split words in a cell
DataText 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. "Gord" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split words in a cell
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 On Fri, 12 Aug 2011 04:10:13 +0300, "m.m.ahmed" wrote: DataText 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. "Gord" wrote in message .. . 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split words in a cell
Thank you, Gord.
"Gord" wrote in message ... 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 On Fri, 12 Aug 2011 04:10:13 +0300, "m.m.ahmed" wrote: DataText 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. "Gord" wrote in message . .. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split string based on a SET of words | Excel Discussion (Misc queries) | |||
Split 2 words | Excel Worksheet Functions | |||
Split sentences into words | Excel Discussion (Misc queries) | |||
Split the words | Excel Discussion (Misc queries) | |||
How do I split a cell of 2 words into two cells | Excel Worksheet Functions |