Text to columns

Ok, it might be that those spaces are not standard char 32 spaces. They
might be char 160 non breaking spaces. In the EditReplace operation:

Find what: hold down the ALT key and using the *numeric keypad* type 0160
let up on the ALT key then type the dash then hold down the ALT key and
using the *numeric keypad* type 0160

Replace with: , (comma)
Replace All
Close

Then do the text to columns

Biff
Microsoft Excel MVP

"B.W." wrote in message
...

I think I did everything you requested but i get a message " cannot find
the
data your searching for"

"T. Valko" wrote:

It looks like you have name space - space number.

Try this:

Select the range of cells in question
Goto the menu EditReplace
Find what: space-space
That is, type in a space then the dash then another space
Replace with: , (type in a comma)
Replace All
Close

With those cells still selected
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"B.W." wrote in message
...
I am trying to split 700 names with phone numbers. They are in
column
A.
There are hyphens between the names and phone numbers. Do I have to
replace
it with a coma and if so can i do the first one and copy it to do the
rest
or
do i have to do each one individually. I not really caught on to this
posting
yet, so please accept my thanks in advance. Any help is very much
appreciated.
ie John Doe - 250-555-5555