Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
Lt
-
Lt
kr
-
kr
€
-
€
SFr.
SFr.
-
.
.
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
UNICHAR Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple UNICHAR formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
68
D
D
TRUE
=UNICHAR(68)
69
C
C
TRUE
=UNICHAR(67)
70
E
E
TRUE
=UNICHAR(69)
71
B
B
TRUE
=UNICHAR(66)
72
C
C
TRUE
=UNICHAR(67)
73
D
D
TRUE
{=UNICHAR(I1:I31)}
74
E
E
TRUE
{=UNICHAR(I1:I31)}
75
F
F
TRUE
{=UNICHAR(I1:I31)}
76
G
G
TRUE
{=UNICHAR(I1:I31)}
77
H
H
TRUE
{=UNICHAR(I1:I31)}
78
I
I
TRUE
{=UNICHAR(I1:I31)}
79
J
J
TRUE
{=UNICHAR(I1:I31)}
80
K
K
TRUE
{=UNICHAR(I1:I31)}
81
L
L
TRUE
{=UNICHAR(I1:I31)}
82
M
M
TRUE
{=UNICHAR(I1:I31)}
83
N
N
TRUE
{=UNICHAR(I1:I31)}
84
O
O
TRUE
{=UNICHAR(I1:I31)}
85
P
P
TRUE
{=UNICHAR(I1:I31)}
86
Q
Q
TRUE
{=UNICHAR(I1:I31)}
87
R
R
TRUE
{=UNICHAR(I1:I31)}
88
S
S
TRUE
{=UNICHAR(I1:I31)}
89
T
T
TRUE
{=UNICHAR(I1:I31)}
90
U
U
TRUE
{=UNICHAR(I1:I31)}
91
V
V
TRUE
{=UNICHAR(I1:I31)}
92
W
W
TRUE
{=UNICHAR(I1:I31)}
93
X
X
TRUE
{=UNICHAR(I1:I31)}
94
Y
Y
TRUE
{=UNICHAR(I1:I31)}
95
Z
Z
TRUE
{=UNICHAR(I1:I31)}
96
[
[
TRUE
{=UNICHAR(I1:I31)}
97
\
\
TRUE
{=UNICHAR(I1:I31)}
98
]
]
TRUE
{=UNICHAR(I1:I31)}
99
^
^
TRUE
{=UNICHAR(I1:I31)}
100
_
_
TRUE
{=UNICHAR(I1:I31)}
101
`
`
TRUE
{=UNICHAR(I1:I31)}
102
a
a
TRUE
{=UNICHAR(I1:I31)}
103
b
b
TRUE
{=UNICHAR(I1:I31)}
104
c
c
TRUE
=UNICHAR(I32)
105
d
d
TRUE
=UNICHAR(I33)
106
e
e
TRUE
=UNICHAR(I34)
107
f
f
TRUE
=UNICHAR(I35)
108
g
g
TRUE
=UNICHAR(I36)
109
h
h
TRUE
=UNICHAR(I37)
110
i
i
TRUE
=UNICHAR(I38)
111
j
j
TRUE
=UNICHAR(I39)
112
k
k
TRUE
=UNICHAR(I40)
113
l
l
TRUE
=UNICHAR(I41)
114
m
m
TRUE
=UNICHAR(I42)
115
n
n
TRUE
=UNICHAR(I43)
116
o
o
TRUE
=UNICHAR(I44)
117
p
p
TRUE
=UNICHAR(I45)
118
q
q
TRUE
=UNICHAR(I46)
119
r
r
TRUE
=UNICHAR(I47)
120
s
s
TRUE
=UNICHAR(I48)
121
t
t
TRUE
=UNICHAR(I49)
122
u
u
TRUE
=UNICHAR(I50)
123
v
v
TRUE
=UNICHAR(I51)
124
w
w
TRUE
=UNICHAR(I52)
125
x
x
TRUE
=UNICHAR(I53)
126
y
y
TRUE
=UNICHAR(I54)
127
z
z
TRUE
=UNICHAR(I55)
{
{
TRUE
=UNICHAR(I56)
|
|
TRUE
=UNICHAR(I57)
}
}
TRUE
=UNICHAR(I58)
~
~
TRUE
=UNICHAR(I59)
TRUE
=UNICHAR(I60)