Can anyone help? I am trying to find a way of easily inserting a value into a string, in a similar manner to the c sprintf function. (Old habits die hard!!)
sTemp = "HELLO WORLD"
'this will place !! in the string,
'after hello.. thus HELLO!! WORLD is now sTemp
sTemp = left(sTemp, 5) & "!!" & right(sTemp, 6)
strName="Fred"
strHomeTown="Smallville"
strOutput = "My Name is " & strName & ", and I come from " & strHomeTown
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.