Enter and replace partial value in two cells

Closed
Chuck - Dec 14, 2009 at 09:32 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2009 at 07:00 AM
Hello,
I 'd like to replace partial values in one cell (A5), after the value entered in the A1. For example,
In A1, I entered New York City. I have a sentence in A5 wirtten as I live in [New York City]. The New York City is in [ ]. Now I changed my value in A1 to Boston to replace New York City, the same value should replace the A5 to I live in [Boston]. Please teach me do the same on the same worksheet and as well as from one worksheet to a different worksheet.

Thanks,

Chuck

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 15, 2009 at 07:00 AM
copy this formula in A5

="I live in["&A1&"]"

be careful about double quote (")

whatever you change in A1 it will be automatically incorporated in A5
0