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

[anthonyzic]

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?

 

[Doug Kanter]

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?

 

[anthonyzic]

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?

 

[Dave Peterson]

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)

 

[Doug Kanter]

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

 

[anthonyzic]

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

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