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")
Related
- Excel - Edit text in specific cells
- Avoiding excel cropping text when next cell contains formula » Forum - Excel
- Excel - Keeping only specific text in a cell » How-To - Excel
- How to use conditional format based on text [Solved] (Solved) » Forum - Excel
- Conditional format range if one cell contains certain text » Forum - Excel
- Conditional Formatting Based on Data in another Cell (Solved) » Forum - Excel