software

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?


quot;anthonyzicquot; gt; wrote in message
...
gt; Basically I have a range of data that has different values in each cell.
gt; I
gt; need to make the same keystroke changes to the whole range but without
gt; 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?

quot;Doug Kanterquot; wrote:

gt;
gt; quot;anthonyzicquot; gt; wrote in message
gt; ...
gt; gt; Basically I have a range of data that has different values in each cell.
gt; gt; I
gt; gt; need to make the same keystroke changes to the whole range but without
gt; gt; changing the values. Is this possible?
gt;
gt; Can you provide one or two examples, please?
gt;
gt;
gt;

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:
gt;
gt; Sure, I have a range of telephone numbers. About 3000. Because they were
gt; entered on the spreadsheet some with the - others with the ( ) it causes
gt; problems. I need to remove the non numerical characters from the data
gt; ranges. Many of the cells require me to do the same key strokes. Does this
gt; clarify what I am trying to do?
gt;
gt; quot;Doug Kanterquot; wrote:
gt;
gt; gt;
gt; gt; quot;anthonyzicquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Basically I have a range of data that has different values in each cell.
gt; gt; gt; I
gt; gt; gt; need to make the same keystroke changes to the whole range but without
gt; gt; gt; changing the values. Is this possible?
gt; gt;
gt; gt; Can you provide one or two examples, please?
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

This is a nice solution. You should see the insanely complicated idea I was
cooking up. I won't say any more. :-)quot;Dave Petersonquot; gt; wrote in message
...
gt; How about getting rid of all those non-numeric characters.
gt;
gt; Select the range (single column???)
gt; And do a series of edit|replaces
gt;
gt; Replace ( with nothing
gt; replace ) with nothing
gt; replace spacebar with nothing
gt; until you get rid of all those characters.
gt;
gt; Then give that range a nice phone number format:
gt; format|cells|number tab|special|phone number
gt; (or what you like)
gt;
gt; anthonyzic wrote:
gt;gt;
gt;gt; Sure, I have a range of telephone numbers. About 3000. Because they
gt;gt; were
gt;gt; entered on the spreadsheet some with the - others with the ( ) it causes
gt;gt; problems. I need to remove the non numerical characters from the data
gt;gt; ranges. Many of the cells require me to do the same key strokes. Does
gt;gt; this
gt;gt; clarify what I am trying to do?
gt;gt;
gt;gt; quot;Doug Kanterquot; wrote:
gt;gt;
gt;gt; gt;
gt;gt; gt; quot;anthonyzicquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt; gt; Basically I have a range of data that has different values in each
gt;gt; gt; gt; cell.
gt;gt; gt; gt; I
gt;gt; gt; gt; need to make the same keystroke changes to the whole range but
gt;gt; gt; gt; without
gt;gt; gt; gt; changing the values. Is this possible?
gt;gt; gt;
gt;gt; gt; Can you provide one or two examples, please?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
Thanks that worked beautifully. I think I was thinking more insanely
complicated myself.

quot;Doug Kanterquot; wrote:

gt; This is a nice solution. You should see the insanely complicated idea I was
gt; cooking up. I won't say any more. :-)
gt;
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; How about getting rid of all those non-numeric characters.
gt; gt;
gt; gt; Select the range (single column???)
gt; gt; And do a series of edit|replaces
gt; gt;
gt; gt; Replace ( with nothing
gt; gt; replace ) with nothing
gt; gt; replace spacebar with nothing
gt; gt; until you get rid of all those characters.
gt; gt;
gt; gt; Then give that range a nice phone number format:
gt; gt; format|cells|number tab|special|phone number
gt; gt; (or what you like)
gt; gt;
gt; gt; anthonyzic wrote:
gt; gt;gt;
gt; gt;gt; Sure, I have a range of telephone numbers. About 3000. Because they
gt; gt;gt; were
gt; gt;gt; entered on the spreadsheet some with the - others with the ( ) it causes
gt; gt;gt; problems. I need to remove the non numerical characters from the data
gt; gt;gt; ranges. Many of the cells require me to do the same key strokes. Does
gt; gt;gt; this
gt; gt;gt; clarify what I am trying to do?
gt; gt;gt;
gt; gt;gt; quot;Doug Kanterquot; wrote:
gt; gt;gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;anthonyzicquot; gt; wrote in message
gt; gt;gt; gt; ...
gt; gt;gt; gt; gt; Basically I have a range of data that has different values in each
gt; gt;gt; gt; gt; cell.
gt; gt;gt; gt; gt; I
gt; gt;gt; gt; gt; need to make the same keystroke changes to the whole range but
gt; gt;gt; gt; gt; without
gt; gt;gt; gt; gt; changing the values. Is this possible?
gt; gt;gt; gt;
gt; gt;gt; gt; Can you provide one or two examples, please?
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt;
gt;
gt;