Manuals/calci/REPEATCHAR

From ZCubes Wiki

Revision as of 04:51, 26 April 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''REPEATCHAR(Char,NumberOfTimes)'''</div><br/> *where <math>Char</math> is the input character or a string, *<math>NumberOfTimes</math> is the tot...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

REPEATCHAR(Char,NumberOfTimes)

where $Char$ is the input character or a string,
$NumberOfTimes$ is the total number of times the given character is to be repeated.

Description

This function repeats the given character for number of times mentioned.
Argument $Char$ can be a character, string or a number.
Argument $NumberOfTimes$ should be a positive value greater than '0'.
For the fractional value of $NumberOfTimes$ , it is rounded off to the nearest integer.

Examples

=REPEATCHAR(4,6) = 444444
=REPEATCHAR(678,3) = 678678678
=REPEATCHAR("Hello",3.6) = HelloHelloHelloHello
=REPEATCHAR(-45.5,5) = -45.5-45.5-45.5-45.5-45.5
=REPEATCHAR(59,-3) = Error

Related Video

How to repeat a character

See Also

REPT
REPLACE

References

Repeat a character in a cell

List of Main Z Functions

Z3 home

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/REPEATCHAR&oldid=207793"