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.
Numbers V3: If cell contains a value, convert cell value to X
numbers
Related Question
- Mac Numbers – How to add up cells containing data (text) per column
- Numbers – Use VLOOKUP to Insert Image Instead of Text
- AppleScript – Setting Value of a Numbers Cell
- Mac – Help with AppleScript to automate Numbers Cell Formatting
- Heatmap in Numbers (colouring cells by their numeric value)
- How to add all of the text strings in all of the cells in a row together
Best Answer
Here are a few hints: