I would rather not use a prefix character.

By the way, I can't even figure out how to do this in VBA without a
copy/paste!!!

Thanks for the reply
--
Gary''s Student - gsnu200901


"Pete_UK" wrote:

You could just type a single apostrophe in A2 (or does that not
count?).

Hope this helps.

Pete

On Aug 21, 5:01 pm, Gary''s Student
wrote:
If I want to enter a null character in a cell, I:

1. enter ="" in A1
2. copy A1
3. select A2
4. paste/special/value

A2 will now contain the null (ISBLANK(A2) will display FALSE)

Is there any way I can accomplish this without using this cumbersome process?
--
Gary''s Student - gsnu200901