Search results for query: *

And to clarify my question, I have no problem if it will copied with the $s (if it can be removed quickly) I didn’t know that there is an f4 function that can add/remove the $s. The only thing is that I’m looking to see how I can add/remove the $s for multiple cells at once. Thanks

Sorry again, YES it works; however, I’m able to it for one cell at a time. Is there a way do it for multiple cells at once? Thanks

Sorry, it works. Thanks thanks

Are you sure it is F4? Nothing happens by me. Is that function adding / removing the $ ??? If so that is what I’m looking for

Let me repeat the question. I do not need the values of the first field. I want to copy the exact calculation again, the same if statement. See example above. Thanks

Is there a way to paste the actual text of a cell (e.g. IF statement, calculation of some fields) not the formulas or values without adding the $? Example A1 =Sheet1!C128 A2 =Sheet1!C129 When I copy row 1 and 2 into row 10 and 11 it will get a mapping of A10 =Sheet1!C138 A11 =Sheet1!C139 I...

I very appreciate your help. I got it to work. Can anyone explain the different between Line feed and Carriage Return Thanks

what is LF and CR

No, No, it does not work. Sorry. Let me clarify the question, I would like to add a hard return every place I have this value --- How do I enter the Alt Enter in the “replace with” field? Tanks

Thanks It worked. However, if the value of the cell is over a limit of characters, it does not work. Any solution.

I’m using Excel 2002 Is it possible to replace a special character (or a combination of mutable) with a hard return? (Alt Enter) Thanks

The link you gave me is more complicated formatting. I need a simple one line code. If G1 = Y then A1, B1, C1, D1, E1, F1 should be green. I select A1, B1, C1, D1, E1, F1, and then I go to conditional formatting, select Formula is, then what do I type. Thanks

If paid = Y the row should be green Order# date customer amount Paid 123456 4/7/2008 Microsoft 520.33 Y 789456 4/7/2008 Excel 214.3 N

I would like to add a conditional formatting (in excel 2002) for the entire line. The color of all columns should be changed based on the information in column G. Is this possible without code? Thanks

Will this also work if additional lines where added to one of the Excel files? YES, I would like to compare it. And thanks for your help. Can you please reply with the method how to compare it? Is it possible to setup a macro to run the compare method for each sheet? The sheet name will be...

How do I do this? That’s also means that I need to copy all sheets from the main documents into the second. Correct?

I’m copying a table from a word documents into excel. However, every hard rerun (Enter) creates a new row in excel. Is there any way to remove all hard returns from a word document? Thanks

MsWord has a build in option to compare and merge documents. I’m trying to compare an excel documents. Is this possible? Does excel also have some kind of tolls for this? Thanks

Yes it worked. The Macro is a bit deferent since I deal with merged fields. Gerry, sorry and thanks for your help. Does it make sense to split this group to the product level?

I’m using excel. Alt-E-S-T and then Enter takes some time and I have a lot of formats to copy. Is there a way to create a macro with the function of Alt-E-S-T and enter? Thanks