Kč
-
Kč
£
-
£
£
-
£
£
-
£
£
-
£
£
-
£
(
)
(
)
£
-
£
£
-
£
€
-
€
R$
-
R$
€
-
€
\
\-
\
\-
\
\-
\
\-
$
($
)
$
($
)
$
($
)
$
($
)
-
-
\
\
-
\
-
-
-
\
\
-
\
-
:
:
:
:
Lt
-
Lt
/
/
-
-
-
-
:
:
:
:
:
:
/
/
:
(
)
(
)
(
)
(
)
(
)
(
)
???
Page 1
??? (???)
00/00/0000, 00:00:00
Page 1 / 99
PROPER Function
Result
TRUE
Sheet
Result
Description
1
TRUE
Simple PROPER formulas with local references and values
Function
Expected
Correct
FunctionString
Comment
this is a TITLE
This Is A Title
This Is A Title
TRUE
=PROPER(I1)
2-way street
2-Way Street
2-Way Street
TRUE
=PROPER(I2)
76BudGet
76Budget
76Budget
TRUE
=PROPER(I3)
Libre Office
Libre Office
TRUE
=PROPER("libre office")
Hello There
Hello There
TRUE
=PROPER("HELLO THERE")
Hello.There
Hello.There
TRUE
=PROPER("HELLO.THERE")
Err:511
error
TRUE
=PROPER()
Labas. Bitä– - Lietuviå² Ä®Monä–
Labas. Bitä– - Lietuviå² Ä®Monä–
TRUE
=PROPER("LABAS. BITĖ - LIETUVIŲ ĮMONĖ")
'Don'T'
Tdf#53146