Shi,

I think Chip may have gone to dinner...

The "Str" function automatically adds a space to contain the sign of the number.
The "Cstr" function would work for you, however it is not required.
The "&" operator will convert the i variable to a string so,
assuming that Sname is a String...

Sname = "START_" & i

is all you need.

Jim Cone
San Francisco, USA



"shishi" wrote in message oups.com...
Hi,
Is there a better way to concatenate strings in excel vba.
The below code is not giving me the desired results. Could you please
tell what could be the reason?
For i = 1 To nmodules
Sname = "START_" & Str(i)
MsgBox "The String is " & Sname
Next i
The result is
START_<space1
START_<space2 .....and so on
Excel is placing a space between the arguments. The desired results is
START_1, START_2 etc.
shi