Trim LAST 3 characters 5

• Jan 16, 2004

1
• #2

woja

Programmer

Jan 5, 2004

438

GB

In VBA use [tt]Right(str, 3)[/tt]; in the spreadheet use a formula [tt]=RIGHT(cell, 3)[/tt].

Hope this helps.

________________________________________
Roger J Coult; Grimsby, UK
In the game of life the dice have an odd number of sides.

 

Upvote 0 Downvote

• Jan 16, 2004

2
• #3

PHV

MIS

Nov 8, 2002

53,708

FR

To remove the last 3 characters of string str:

Code:

str=Left(str,Len(str)-3)

Hope This Help
PH.

 

Upvote 0 Downvote

• Jan 16, 2004

• #4

woja

Programmer

Jan 5, 2004

438

GB

Sorry, mis-read your question: I was illuestrating how to get the last three characters. Your question seems to say; "How do I get all but the last three characters?":

Code:

   strExceptLast3 = Left(strToExtractFrom, Len(strToExtractFrom) - 3)

The formula is [tt]=LEFT(cell, LEN(cell) - 3)[/tt].
OK?

________________________________________
Roger J Coult; Grimsby, UK
In the game of life the dice have an odd number of sides.

 

Upvote 0 Downvote

• Jan 16, 2004

1
• #5

SQLBI

IS-IT--Management

Jul 25, 2003

988

GB

Woja, EB24 wants to remove the last 3 letters as i read the post, where as your solution will return the last 3:

To Trim the string, thus removing the last 3 characters try

VBA:

Code:

Left(str, Len(str)-3)

XL:

Code:

Left(cell, Len(cell)-3)

Hope this helps.






Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

Upvote 0 Downvote

• Jan 16, 2004

1
• #6

TonyJollans

Programmer

Dec 18, 2002

7,186

GB

Hi eb24,

If your data is in A1 ..

=LEFT(A1,LEN(A1)-3)

.. or, if any of your cells might contain less than 4 characters, you would be better checking the length ..

=IF(LEN(A1)>3,LEFT(A1,LEN(A1)-3),"&quot

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

Upvote 0 Downvote

• Jan 16, 2004

• #7

SQLBI

IS-IT--Management

Jul 25, 2003

988

GB

Wow... it's amazing what happens to a thread whilst you're writing a reply.


Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

Upvote 0 Downvote

• Jan 16, 2004

• Thread starter
• #8

eb24

Programmer

Dec 17, 2003

240

US

Holy Cow!!!

I stepped away from my desk for a minute and I saw all these posts already!!! Thanks for all of your suggestions! It works perfectly!!

 

Upvote 0 Downvote

• Jan 16, 2004

• #9

TonyJollans

Programmer

Dec 18, 2002

7,186

GB

Tek-Tips .. faster than a speeding bullet

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

Upvote 0 Downvote