Re: Why not accept wildcards for REPLACE as well as FIND ?
- From: The Blue Max <TheBlueMax@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 25 Jul 2007 09:32:05 -0700
There may be another simple method also, depending on what other formulas you
have included in the range. Try the following:
1. Select the range of cells to be changed.
2. Search for the function "Round(" and replace it with nothing.
3. Now Search for the trailing parameter ";4)" and replace it with nothing.
This process should leave you with only the cell references used as the
first argument.
Good Luck
***********************
"Stefan" wrote:
On Jul 12, 5:20 am, The Blue Max.
<TheBlue...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Why not allow matchingwildcards(? and *) in theREPLACEstring as well as
in the FIND string? Using the Excel FIND ANDREPLACEfeature is handicapped
by the inability to copy the wildcard strings from the FIND operation and
restore it as part of theREPLACEoperation. Often users want to use the
wildcard characters as a template to find strings in order toreplacethe
common component, but do NOT want toreplacethe wildcard component.
For example, we want to FIND Building 1A1, Building 2B2, and Building 3C3
andREPLACEit with Building 1-A1, Building 2-B2, and Building 3-C3. This
could easily be performed if we could search for "Building ???" andreplace
it with "Building ?-??", where thewildcards(?-??) in thereplacestring are
replaced by the wildcard characters found in the search string.
Unfortunately, using this example in the current version of Excel 2007, will
simplyreplaceall the numbers with question marks instead of preserving the
wildcard characters in the find string.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=4aa6...
I am just having a similar problem....this is very annoying
indeed...and would be very easy to change I suppose...
So if I am not wrong it is not possible to replace for example
=ROUND(A1*B1;4)
by
= A1*B1
with the help of the replace function in excel....
I have a huge amount of sheets where I want to get rid of the round
function.....
would be great to find an automatic solution....
any suggestiongs?
thanks in advance!
Stefan
- References:
- Prev by Date: Re: how can i have more than 30 arguements in a SUM
- Next by Date: Re: ByVal Target Range Great Code but need Help
- Previous by thread: Re: Why not accept wildcards for REPLACE as well as FIND ?
- Next by thread: Re: Temperature (degree) symbol
- Index(es):
Relevant Pages
|
