Posted to microsoft.public.excel.programming

tonyv

external usenet poster

Posts: 5

Need macro to trim characters in column

I have a 100 lines in column A in my excel 2003 spreadsheet, each containing
various lengths of text, and need to trim each cell to contain the first 21
characters only & discard the rest.

I will be greatful if someone can assist me in writing a macro to get this
done that will be equivalent the LEFT formula.

Thankyou.

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
Convert column data to trim all characters and leave the last 6	S Himmelrich	Excel Programming	5	December 14th 07 10:14 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 12:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us