Posted to microsoft.public.excel.programming

Craig[_8_] Craig[_8_] is offline

external usenet poster

Posts: 18

Trim the last two characters?

Hi folks,
I'm new to VBA, but I've programmed in VB (a little bit)
before. I have several cells that I simply need to trim
off the last 2 characters from. Is there a function in
Excel that can do that?...or does someone know of a
function that will do that? I frequently have something
like: 373.62CR and I need to keep the numeric portion, but
lose the text portion. Suggestions???

Thanks,
Craig

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trim out last seven characters from a string...	DubboPete	Excel Discussion (Misc queries)	3	February 2nd 10 05:16 AM
Trim characters	Ronbo	Excel Worksheet Functions	7	January 26th 09 09:29 PM
Trim hidden characters?	robotman	Excel Worksheet Functions	3	October 20th 07 12:00 AM
How do you trim characters?	Tommi	Excel Worksheet Functions	6	January 29th 06 01:38 PM
Trim characters	Ange[_3_]	Excel Programming	1	August 25th 04 07:31 PM

All times are GMT +1. The time now is 07:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us