Friday, 15 April 2011

Character 0 in Excel -



Character 0 in Excel -

the documentation char(number) states:

number: number between 1 , 255...

=char(1) , =char(255) works, there work around char(0) or impossible due 0 terminated string rules?

i suspect excel uses zero-terminated strings internally.

a string returned vba function includes null truncated @ null when used in excel formula.

excel-formula

No comments:

Post a Comment