Enter and replace partial value in two cells [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!