And just to add onto Dave reply, the String function only repeats single
characters; however, if you wanted to repeat multiple characters, all you
would have to do is couple the String or Space function with the Replace
function. For example, to produce a text string of, say, 100 "XO" character
pairs in a row, just do this...
HundredXOs = Replace(Space(100), " ", "XO")
or this would work also...
HundredXOs = Replace(String(100, "Z"), "Z", "XO")
where you can use any character you want to in place of the "Z".
Rick (MVP - Excel)