Results 1 to 8 of 8

How can I replace a word from a sentence in a cell & substitute word from another cell

Threaded View

rionoah How can I replace a word from... 09-11-2012, 07:55 AM
rionoah Re: How can I replace a word... 09-11-2012, 07:59 AM
DannyJ Re: How can I replace a word... 09-11-2012, 08:16 AM
rionoah Re: How can I replace a word... 09-11-2012, 08:39 AM
rionoah Re: How can I replace a word... 09-14-2012, 01:25 AM
nested.if1@gmail.com Re: How can I replace a word... 09-11-2012, 08:22 AM
DannyJ Re: How can I replace a word... 09-11-2012, 08:36 AM
DannyJ Re: How can I replace a word... 09-11-2012, 08:44 AM
  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    31

    Post How can I replace a word from a sentence in a cell & substitute word from another cell

    How can I replace a word from a sentence in a cell and substitute the word from another cell.
    example:

    A1 > apple
    A2 > banana
    A3 > carrot
    .
    .
    A100 > grape

    B1 > I ate food this morning (using ONLY cell B1 as source of sentence)

    **this is the OUTPUT after replacing word "food"
    C1 > I ate apple this morning
    C2 > I ate banana this morning
    C3 > I ate carrot this morning
    .
    .
    C100 > I ate grape this morning
    Last edited by rionoah; 09-11-2012 at 08:03 AM. Reason: missing statement

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