| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace a cell (I2) with a cell (H2) if I2 = "a"
I am trying to replace a cell I2 with a cell H2's contents if cell I2 is
equal to the letter a. NOTE: The cell has the letter a preceeded by the single quote: 'a It, the single quote, of course is not visible, but when you look in the formula display box you can see the single quote. Thanks. Also, if this is code, could you tell me how to inject/insert the code into the excel spreadsheet and then run it. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find blank cell and replace with " ' " | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows. | Excel Programming | |||
| Find and Replace causing a "Text" cell to become a custom date--wh | Excel Discussion (Misc queries) | |||
| How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming | |||
Threaded Mode
