August,

Use one of the str = formulas below (watch for word wrap)

Dim str As String

str = Left("XCMWTC.MMMTTT.KKKT", 13)
str = Left("XCMWTC.MMMTTT.KKKT", Len("XCMWTC.MMMTTT.KKKT") - 5)

or
Dim str1 as String, str2 as String

str1 = "XCMWTC.MMMTTT.KKKT"
str2 = Left(str1,13)
str3 = Left(str1,Len(str1)-5)

--
sb
"August" wrote in message
...
Hi There,

I am writing vba code in macro, How could I concatenate a
string where I want only the middle text of the string.
Something like this: "This is my string sample,
XCMWTC.MMMTTT.KKKT." and I wanted only the "XCMWTC.MMMTTT"
and I will make this as my filenme. How could I do this?

Please help me. thanks.
August