If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|