| 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
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? |
|
#4
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? |
| 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 | |||
Hybrid Mode
