Excel - Edit text in specific cells

August 2017




Issue


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.

Solution


Try this:
=IF(C11 = "X";"Y";"Text")

Related


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 (ccm.net).