Excel - Edit text in specific cells

October 2016


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")

Related :

This document entitled « Excel - Edit text in specific cells » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.