editing strings
 

How do I remove the last three letters of a string?

editing strings
 

strMyString = left(trim(strOldstring)), len(trim(strOldstring))-3)

HTH

"Himszy" wrote:

How do I remove the last three letters of a string?

editing strings
 

Since this is in the Programming section, I assume you want to use VBA. You
can use
MyString=Left(MyString,Len(MyString)-3)


Bob Umlas
Excel MVP
"Himszy" wrote in message
. ..
How do I remove the last three letters of a string?

editing strings
 

sStr = "abcdefgh"
sStr = Left(sStr,len(sStr)-3)

--
Regards,
Tom Ogilvy

"Himszy" wrote in message
. ..
How do I remove the last three letters of a string?