Posted to microsoft.public.excel.programming

Annette[_5_] Annette[_5_] is offline

external usenet poster

Posts: 9

Trim all but the first 5 characters in cell

How would I write the trim to leave only the first five characters in a
column?

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 characters	Ronbo	Excel Worksheet Functions	7	January 26th 09 09:29 PM
Trim Characters Other Than An Empty Space At The End Of A Cell	K8_Dog	Excel Worksheet Functions	5	April 19th 08 01:29 AM
How do you trim characters?	Tommi	Excel Worksheet Functions	6	January 29th 06 01:38 PM
Trim the last two characters?	Craig[_8_]	Excel Programming	4	September 7th 04 02:52 AM
Trim characters	Ange[_3_]	Excel Programming	1	August 25th 04 07:31 PM

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

About Us

"It's about Microsoft Excel"