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

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

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

Range("a10:a20")= CHR(39)

If this post helps click Yes
---------------
Jacob Skaria


"Gary''s Student" wrote:

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

"Gary''s Student" wrote:
I would rather not use a prefix character.
By the way, I can't even figure out how to do this in VBA

I think you want a cell that is treated as text (specifically the null
string), but the cell contains no visible characters and no formula. TYPE()
should return 2, LEN() should return 0, and ISBLANK() should return FALSE
(or perhaps that's what you want to determine).

If you are content to change the cell format to Text, then:

range("a1").numberformat = "@"
range("a1") = ""

If you want to preserve the original format (e.g. General), then:

oldform = range("a1").numberformat
range("a1").numberformat = "@"
range("a1") = ""
range("a1").numberformat = oldform

I'd be interested in a simpler way. Neither of the following works:

range("a1") = ""

or

range("a1").value2 = ""


----- original message -----

"Gary''s Student" wrote in message
...
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