Results 1 to 8 of 8

Muti find & replace function

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    118

    Muti find & replace function

    Hi,

    Is there an easy way to find and replace text in a spreadsheet using a formula.

    For example I have the word Japan which is shown approx 12 times in various places in a large table C1:K500, I would like to replace the word Japan with Japan ABC 1000.

    I have 30 other country's that also require a new name in the same sheet.

    I can obviously use Ctrl H, but this would take a long time. Is there a formula I could use from a look up table, i.e find in sheet C1:K500 the word "Japan" which is in cell A1 and replace with the new word in B1 2Japan ABC 1000"

    Appreciate any help.
    Last edited by junada0; 05-04-2010 at 02:35 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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