Excel - Edit text in specific cells

April 2018

I want to make the text of some cells be replaced based on a selection or on the value of another cell.
  • I can make the choice for a cell between X and Y (for data validation function).
  • Based on the choice I made the value of certain cell will be replaced.

Try this:
=IF(C11 = "X";"Y";"Text")
Published by aakai1056. Latest update on April 17, 2013 at 10:32 AM by deri58.
This document, titled "Excel - Edit text in specific cells," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
How To Convert Numbers to Words in Excel
Excel - Delete text up to a particular character