Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a text with another
Hi All, In excel I have 2 sheets (Sheet1 & Sheet2), in the same workbook(Book1.xls). Sheet2 is refering to Sheet1 to get values in different cells in Sheet2. I want for example, whever there's a text * XYZ * in sheet2, replace that text with * W1P * in Sheet2. I have like 20 kind of text that on any cell found need to be replace by some other 20 text. This I want to accomplish on Sheet2 I have no clue about VBA/Macros. I dont want to find/replace, since I have many many sheets & it will be time consuming. How can I achieve this?. Whats the quickest & easiest way to do it?. Any help would be appreciated. Thanks, -- zeeshan13 ------------------------------------------------------------------------ zeeshan13's Profile: http://www.excelforum.com/member.php...o&userid=32911 View this thread: http://www.excelforum.com/showthread...hreadid=527329 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) | |||
Replace Number with Text using Macro | Excel Discussion (Misc queries) | |||
Macro to delete and replace a text box | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |