+ Reply to Thread
Results 1 to 3 of 3

Replace text in a range of cells

  1. #1
    Registered User
    Join Date
    02-15-2019
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    2

    Replace text in a range of cells

    Hello. Is it possible in Excel to replace words in a range of cells with different words that I've put in another column? Here is a simplified example:

    example.png

    Here I'd like to replace cells from E5 to H5 based on the two columns on the left. So that "apple" is replaced with "socks", "pear" with "shoes", "melon" with "skirt" and "pineapple" with "shoes".

    I hope it's not too trivial. I couldn't work that out. In my project the data is of course more complicated but I think it boils down to just this.
    Thank you very much!
    Last edited by nightoul; 11-07-2019 at 10:47 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    6,931

    Re: Replace text in a range of cells

    Cells can contain a value or a formula, not both.

    The solution requires a formula so you cant change the values in the cells (unless you use VBA).

    But you could use other cells to produce the result you want.

    in E6
    =VLOOKUP(E5,$A5:$B8,2,0)
    and copy across to H6

    Now use the values in E6:H6 instead of E5:H5
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    11-08-2019
    Location
    London
    MS-Off Ver
    2010
    Posts
    2

    Re: Replace text in a range of cells

    Thanks for your comment

+ 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