Prev: updating two seperate spreadsheets with same info
Next: If statment
From: Going Crazy with excel on 28 May 2010 15:05
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

From: tim m on 28 May 2010 15:14
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
>
From: Don Guillett on 28 May 2010 15:16
delimited>other> -

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Going Crazy with excel" <GoingCrazywithexcel(a)discussions.microsoft.com>
wrote in message news:223F6C5D-210A-4DE9-81CF-14274CB4ABCF(a)microsoft.com...
> 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
>

 | 
Pages: 1
Prev: updating two seperate spreadsheets with same info
Next: If statment