Try this
NEWFILE = "" & Range("C" & x).Value & ""

"geebee" wrote:

hi,

i have the following:

Dim NEWFILE As String
NEWFILE = Range("C" & x).Value
...
Dim test As String
test = Evaluate("LEFT(NEWFILE,FIND(""_"", NEWFILE ,1)-1)")

not sure what is wrong with the syntax

thanks in advance,
geebee