Thanks that worked beautifully. I think I was thinking more insanely
complicated myself.

"Doug Kanter" wrote:

This is a nice solution. You should see the insanely complicated idea I was
cooking up. I won't say any more. :-)


"Dave Peterson" wrote in message
...
How about getting rid of all those non-numeric characters.

Select the range (single column???)
And do a series of edit|replaces

Replace ( with nothing
replace ) with nothing
replace spacebar with nothing
until you get rid of all those characters.

Then give that range a nice phone number format:
format|cells|number tab|special|phone number
(or what you like)

anthonyzic wrote:

Sure, I have a range of telephone numbers. About 3000. Because they
were
entered on the spreadsheet some with the - others with the ( ) it causes
problems. I need to remove the non numerical characters from the data
ranges. Many of the cells require me to do the same key strokes. Does
this
clarify what I am trying to do?

"Doug Kanter" wrote:


"anthonyzic" wrote in message
...
Basically I have a range of data that has different values in each
cell.
I
need to make the same keystroke changes to the whole range but
without
changing the values. Is this possible?

Can you provide one or two examples, please?




--

Dave Peterson