format string

How do I format a big long string thats stuck in a variable to insert a character every so many characters.

Suedo code:
function(1ZillionCharacterString,",",5) returns XXXXX,XXXXX,XXXXX,XXXXX,...

This what you want?

Code:

---

ZillionCharacterString = "1000000000000000000000000"
MsgBox Format(ZillionCharacterString, "#####,#####,#####,#####,#####")

---

Hi Mat,
I don't want to format it that way because I would be making #'s forever and I'd also need to know the string length. Isn't there a function to do this?

To find out a string's length, use the Len function.

Code:

---

Msgbox Len("MyText")

---