editing strings

Himszy · Dec 31, 2004

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

Guest · Dec 31, 2004

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

HTH

Bob Umlas · Dec 31, 2004

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

Tom Ogilvy · Dec 31, 2004

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

Combine three InputBoxes into one?	7	May 24, 2014
Userform textbox string to header causes unwanted double spacing	4	Nov 17, 2014
Cut off end of a string	8	Mar 3, 2009
Set a Range to a variable	15	Feb 13, 2013
Strings	2	Feb 15, 2008
List found strings on sheet	34	Jun 26, 2014
extracting chars from strings (Visual Basic)	3	Oct 23, 2009
Help with a regex pattern please	3	Mar 20, 2008

Ask a Question