Find and replace with adjacent cell value.

**james252** · 08-12-2014, 03:27 AM

Hi guys,

I am seeking a help to search a variable in column A and Replace that variable only with the adjacent value of Column B.

In the attached file, there are common variable i.e. $title in Column A from A1:A10 ,
I want to replace $title var in Cell A1 with adjacent value in Cell B1, $title in A2 with value in cell B2 and so on....$title in cell A10 with value in cell B10.

Please note that i just want to replace value of var $title with adjacent cell B value but not the whole cell itself.

Thanks for the help.

**sweep** · 08-12-2014, 03:54 AM

Hi,

I fear that it may not be as simple as this, but you can achieve the desired result by entering in cell C1,

=SUBSTITUTE(B1,"$title",A1)

and copying down.

**boopathiraja** · 08-12-2014, 03:56 AM

Try

=SUBSTITUTE(B1,"$title",A1)

Find and replace with adjacent cell value.

LinkBack

Thread Tools

Rate This Thread

Display

Find and replace with adjacent cell value.

Re: Find and replace with adjacent cell value.

Re: Find and replace with adjacent cell value.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to find duplicate value and replace adjacent cell with different value

Macro to find all specific values in column and replace adjacent cell values

Find String and Replace With Adjacent Cell

find and replace - based on 3 character in adjacent cell

Find, Replace with and then replace adjacent cell

Bookmarks

Bookmarks

Posting Permissions