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
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
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
Related:
- Enter and replace partial value in two cells
- How to enter @ in laptop - Guide
- Enter coordinates in google earth - Guide
- How to enter in wechat - Guide
- Enter is send in whatsapp - Guide
- How to replace a word in word - Guide
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
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
="I live in["&A1&"]"
be careful about double quote (")
whatever you change in A1 it will be automatically incorporated in A5