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