Results 1 to 7 of 7

Creating a macro to search string in a range of cells and replace while leaving original

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    Tijuana, Mexico
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    4

    Creating a macro to search string in a range of cells and replace while leaving original

    Hi all, I am new to this forum. Hope I can get some help on this matter.

    So I was given the task to translate some procedure instructions in an Excel file from English to Spanish. These are very simple instructions and in most cases repetitive throughout the document. There are a lot of instances where the instructions are the same except for a #. They are meant to be modified within the cell as the text that appears in the cell will be printed exactly as it appears.There are several instructions in the cell, it is basically a long continuous string in the cell. My idea is to create a macro that can search that range of cells for the instruction, replace it with the Spanish equivalent while leaving the original English instruction in the cell. Any ideas on how can I go and do this on Excel? Any links to other forum threads I can read on ?

    Thanks in advance.

    JCarlos
    Last edited by JCarlos; 07-25-2014 at 02:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating search box in cell - Currently using Macro 'Range to search' *HELP*
    By jacko058 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 05:24 AM
  2. [SOLVED] Search through cells, if I find a string (external Link), replace it with a formula
    By Vaslo in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-17-2012, 04:41 PM
  3. Replies: 5
    Last Post: 03-08-2012, 01:50 AM
  4. How to insert Cells VALUE (Search and Replace Macro)
    By NatanZ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-30-2010, 01:58 PM
  5. Replies: 24
    Last Post: 04-15-2009, 09:24 AM

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