In Excel, how do I make the same changes to different values?
 

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?

In Excel, how do I make the same changes to different values?
 

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

In Excel, how do I make the same changes to different values?
 

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?

In Excel, how do I make the same changes to different values?
 

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

In Excel, how do I make the same changes to different values?
 

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

In Excel, how do I make the same changes to different values?
 

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