Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing part of a cell text
Hi there! I'm working on a macro to automate my project, One thing i need to do now is to replace the numerals in a cell from another cell. For example, in sheet1 C2, i have this numeral 20. I will like this macro to replace sheet3 C2 which contains data such as 11. I want the numeral 11 to be replaced by 20. Hope someone can help with this! Another thing is how do i call from excel macro to ask notepad to open up a .xml file? Thanks a lot! -- oOpsy ------------------------------------------------------------------------ oOpsy's Profile: http://www.excelforum.com/member.php...o&userid=29132 View this thread: http://www.excelforum.com/showthread...hreadid=489705 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing text in a cell with blanks | Excel Discussion (Misc queries) | |||
Replacing Part of a Cell's Content | Excel Worksheet Functions | |||
Replacing part of a (too) long formula | Excel Discussion (Misc queries) | |||
replacing text in a cell | Excel Discussion (Misc queries) | |||
Replacing Text in a Cell Reference | Excel Programming |