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,...
Printable View
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")