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?

"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?

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?

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

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

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