Numbers V3: If cell contains a value, convert cell value to X I have a spreadsheet which contains a mixture of text strings and empty cells. I'm looking for a formula to replace the value of all non-empty cells with a single character 'x', while leaving empty cells blank.
Here are a few hints:


use an auxiliary column;
use functions ISBLANK and IF;
replicate the auxiliary column within the original one;
remove the auxiliary column.