Find Not Null Cells Within a Column and Replace with X

NicoleMA

I'm very new and not good with the expressions so I can't figure out how to find any cells within a column that contain text (are not null) and replace that text with "X". I thought find and replace would be the way to go, but couldn't figure that out. Then I thought it would be just an expression in the formula tool, but I don't know how to edit the expressions to be anything other than they read. I was thinking: IF c THEN t ELSE f ENDIF?

In the same below I want to replace (San Jose) with an X and leave the other cells in that column blank.

ZIP	Sales	SPH	Home ZIP
60126	2000	100
60515	200	200	San Jose
60559	500	20	San Jose
85210	10000	700

Hopefully this IS as easy as I thought and someone can help me out! Thanks!

PamW

Try this

IF IsEmpty([Home ZIP]) THEN
   Null()
ELSE
   "X"
ENDIF

If the field is truly null you can use the following:

IF IsNull([Home ZIP]) THEN
   Null()
ELSE
   "X"
ENDIF

Note that in the below post there was an extra parenthesis before the IsNull() (shown in bold below)

IF (IsNull([Home ZIP]) THEN

   Null()

ELSE

   "X"

ENDIF