Recent content by Joe1010

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