| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Column will not cooperate
Looking to separate two names in a cell, separated by a Hyphen.
It will not separate the names. Is there a formula that will work to separate them? Example: george-smith |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to Column will not cooperate
Text to columns should (just worked in my test).
Did you do 'text to columns'...'deliminated'...click in the 'other' box and enter the hyphen in the small window next to it. It should work that way. "Going Crazy with excel" wrote: Looking to separate two names in a cell, separated by a Hyphen. It will not separate the names. Is there a formula that will work to separate them? Example: george-smith |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to Column will not cooperate
delimitedother -
-- Don Guillett Microsoft MVP Excel SalesAid Software "Going Crazy with excel" wrote in message ... Looking to separate two names in a cell, separated by a Hyphen. It will not separate the names. Is there a formula that will work to separate them? Example: george-smith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting doesn't want to cooperate | Excel Worksheet Functions | |||
| How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
![Going Crazy with excel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
