+ Reply to Thread
Results 1 to 3 of 3

How to replace a text with another

Hybrid View

  1. #1
    Registered User
    Join Date
    03-28-2006
    Posts
    3

    Exclamation 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,

  2. #2
    Don Guillett
    Guest

    Re: How to replace a text with another

    sheet 1 & sheet2 are not many many sheets. use find/replace on the sheet
    desired.

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "zeeshan13" <zeeshan13.25eg4z_1143582303.4473@excelforum-nospam.com> wrote
    in message news:zeeshan13.25eg4z_1143582303.4473@excelforum-nospam.com...
    >
    > 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=527328
    >




  3. #3
    Registered User
    Join Date
    03-28-2006
    Posts
    3
    Don Guillett...
    Thanks for the feed back.
    But in the problem, I just give an example for Sheet1 & Sheet2.

    Can anyone help me on this?.


    Thanks,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1