Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
editing strings
How do I remove the last three letters of a string?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
editing strings
strMyString = left(trim(strOldstring)), len(trim(strOldstring))-3)
HTH "Himszy" wrote: How do I remove the last three letters of a string? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming | |||
Finding strings within strings | Excel Programming |