search and add string to a cell value (case insensitive)

[bharath235]

in one cell (say A1) I have a word, example - apple

in the next cell (say A2) I have a sentence, example - An APPLE a day keeps the doctor away

is it possible to render the following result in another cell (say A3)? - An <span class="highlight">APPLE</span> a day keeps the doctor away

please note that I tried search, find, substitute, and replace, the real problem I am facing is that the text in A1 and A2 can be of different cases and are absolute variables ... can a vba function be written to solve this?

Thanks for your help!

 

[bharath235]

sorry there was an error in the post for cell A3...

in one cell (say A1) I have a word, example - apple

in the next cell (say A2) I have a sentence, example - An APPLE a day keeps the doctor away

is it possible to render the following result in another cell (say A3)? - An <span>APPLE</span> a day keeps the doctor away

please note that I tried search, find, substitute, and replace, the real problem I am facing is that the text in A1 and A2 can be of different cases and are absolute variables ... can a vba function be written to solve this?

Thanks for your help!

 

[bharath235]

hi everyone .. please ignore this post .. i tried to include some html tags, which did not get published for some reason .. i will open a new thread ... thx