Funkcji tekstowe

[ ] indicates optional parameters

DŁ(tekst)
FRAGMENT.TEKSTU(tekst, liczba_początkowa, liczba_znaków)
KOD(tekst)
KWOTA(liczba, [miejsca_dziesiętne])
LEWY(tekst, [liczba_znaków])
LITERY.MAŁE(tekst)
LITERY.WIELKIE(tekst)
OCZYŚĆ(tekst)
PODSTAW(tekst, stary_tekst, nowy_tekst, [wystapienie_liczba])
PORÓWNAJ(tekst1, tekst2)
POWT(tekst, ile_razy)
PRAWY(tekst, [liczba_znaków])
SZUKAJ.TEKST(szukany_tekst, wewnątrz_tekst, [liczba_początkowa])
T(wartość)
TEKST(wartość, format_tekst)
USUŃ.ZBĘDNE.ODSTĘPY(tekst)
WARTOŚĆ(tekst)
Z.WIELKIEJ.LITERY(tekst)
ZAOKR.DO.TEKST(liczba, [miejsca_dziesiętne], [bez_przecinka])
ZASTĄP(stary_tekst, liczba_początkowa, liczba_znaków, nowy_tekst)
ZNAJDŹ(szukany_tekst, wewnątrz_tekst, [liczba_początkowa])
ZNAK(liczba)
ZŁĄCZ.TEKSTY(tekst1, [tekst2, ...])


Funkcji tekstowe

DŁ(tekst)

Returns the length of the input string.

tekstThe string of which you want the length.


FRAGMENT.TEKSTU(tekst, liczba_początkowa, liczba_znaków)

Returns a string consisting of the specified number of characters from the specified position of the input string.

tekstThe string of which you want the extract.
liczba_początkowaThe starting position of characters to extract from the string.
liczba_znakówThe number of characters to extract from the string.


KOD(tekst)

Returns the position in the character set of the first character in the string.

tekstThe character of which you want the character code.


KWOTA(liczba, [miejsca_dziesiętne])

Returns a string consisting of the input number rounded to the specified number of decimal places and converted to currency format.

liczbaThe amount that you want to format.
miejsca_dziesiętneThe number of decimal places required. If this parameter is omitted it defaults to 2.


LEWY(tekst, [liczba_znaków])

Returns a string consisting of the specified number of characters from the beginning of the input string.

tekstThe string of which you want the beginning.
liczba_znakówThe number of characters to extract from the string. If this parameter is omitted it defaults to 1.


LITERY.MAŁE(tekst)

Returns a string which is the input string with all of the characters converted to lower case.

tekstThe string you want to convert.


LITERY.WIELKIE(tekst)

Returns a string which is the input string with all of the characters converted to upper case.

tekstThe string that you want to convert.


OCZYŚĆ(tekst)

Returns a string corresponding to the input string with any unprintable characters removed.

tekstThe text from which you want to remove unprintable characters.


PODSTAW(tekst, stary_tekst, nowy_tekst, [wystapienie_liczba])

Returns a string which is the input string with specified text replaced.

tekstThe string you want to convert.
stary_tekstThe string to be removed from the original text.
nowy_tekstThe string to be inserted in the original text.
wystapienie_liczbaSpecifies which occurrence of old_text is to be replaced. If this parameter is omitted then all occurrences are replaced.


PORÓWNAJ(tekst1, tekst2)

Returns PRAWDA if the input strings are exactly the same, otherwise FAŁSZ.

tekst1The first string to be compared.
tekst2The second string to be compared.


POWT(tekst, ile_razy)

Returns a string which is the input string repeated a specified number of times.

tekstThe string you want to repeat.
ile_razyThe number of times to repeat the string.


PRAWY(tekst, [liczba_znaków])

Returns a string consisting of the specified number of characters from the end of the input string.

tekstThe string of which you want the end.
liczba_znakówThe number of characters to extract from the string. If this parameter is omitted it defaults to 1.


SZUKAJ.TEKST(szukany_tekst, wewnątrz_tekst, [liczba_początkowa])

Returns a number corresponding to the position of one text string within another (not case-sensitive).

szukany_tekstThe text you want to find.
wewnątrz_tekstThe text to be searched.
liczba_początkowaThe position at which to start searching. If this parameter is omitted it defaults to 1.


T(wartość)

Returns a string which is the input value if it is text, otherwise an empty string.

wartośćThe value you want if it is a string.


TEKST(wartość, format_tekst)

Returns a string consisting of the input number formatted using the specified format string.

wartośćThe number that you want to format.
format_tekstThe format string to use.


USUŃ.ZBĘDNE.ODSTĘPY(tekst)

Returns a string consisting of the input string with any extra spaces removed.

tekstThe string that you want to format.


WARTOŚĆ(tekst)

Returns a number which corresponds to the value in the input string. You should not need to use this function, as values are automatically converted from text to numeric when required in formulas.

tekstThe string that you want to convert to a number.


Z.WIELKIEJ.LITERY(tekst)

Returns a string which is the input string with the first letter of each word converted to upper case and all of the other characters converted to lower case.

tekstThe string you want to convert.


ZAOKR.DO.TEKST(liczba, [miejsca_dziesiętne], [bez_przecinka])

Returns a string consisting of the input number rounded to the specified number of decimal places.

liczbaThe number that you want to format.
miejsca_dziesiętneThe number of decimal places required. If this parameter is omitted it defaults to 2.
bez_przecinkaSpecifies whether to suppress the thousands separator in the formatted number. The possible values are:
FAŁSZThe thousands separator is used.
PRAWDAThe thousands separator is not used.
If this parameter is omitted it defaults to FAŁSZ.


ZASTĄP(stary_tekst, liczba_początkowa, liczba_znaków, nowy_tekst)

Returns a string which is the input string with a specified portion replaced.

stary_tekstThe string you want to convert.
liczba_początkowaThe starting position of the text to be removed.
liczba_znakówThe number of characters to be removed.
nowy_tekstThe text to be inserted into the string.


ZNAJDŹ(szukany_tekst, wewnątrz_tekst, [liczba_początkowa])

Returns a number corresponding to the position of one text string within another (case-sensitive).

szukany_tekstThe text you want to find.
wewnątrz_tekstThe text to be searched.
liczba_początkowaThe position at which to start searching. If this parameter is omitted it defaults to 1.


ZNAK(liczba)

Returns the character corresponding to the specified position in the character set.

liczbaThe number of the character that you want.


ZŁĄCZ.TEKSTY(tekst1, [tekst2, ...])

Returns a string consisting of the input strings concatenated together.

tekst1, ...The strings that you want to concatenate.