Results 1 to 4 of 4

Replace the word in A1 in the sentence in B1 with ( )

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    Tokyo
    MS-Off Ver
    Win 10
    Posts
    2

    Replace the word in A1 in the sentence in B1 with ( )

    I have over 5,000 entries I need to do this to....but only 2 examples are attached here.

    Column A has 1 word entries. For example "bear"
    Column B has a sentence using the word from column A. For example "The bear lives in the woods"

    I need to replace the Column A word in the sentence with ( ) brackets.

    The final result in Column B will be
    ( ) lives in the woods.
    The altered sentence can be placed in Column C if that helps.

    The problem I`m having is, that this is all done in Japanese and macros don`t play nice with Japanese characters.
    So I`m looking for another way.

    Would anyone have any thoughts?

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 01-30-2018, 09:13 AM
  2. Replies: 4
    Last Post: 03-12-2015, 12:45 PM
  3. Find and replace a new sentence or paragraph in word doc
    By krazyhype19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-03-2014, 06:06 AM
  4. [SOLVED] Find and Replace Exact Word in Sentence.
    By rr1050 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2014, 01:58 AM
  5. Replace word in a sentence
    By dmarop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2014, 02:50 PM
  6. [SOLVED] How can I replace a word from a sentence in a cell & substitute word from another cell
    By rionoah in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2012, 08:44 AM
  7. How to find and replace a word in a sentence with VBA
    By Gunilla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-20-2010, 09:52 PM

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