Posted to microsoft.public.excel.programming

[email protected] james.y.so@gmail.com is offline

external usenet poster

Posts: 6

Trimming Characters

Hi there,

I've downloaded some data in excel but with an unwanted character both
at the front and the end of each of the cell. Please help with a macro
to remove both the first and the last characters of the the cells from
say A1:A500. Thanks in advance.

James

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
Trimming down a file	Novice Lee	Excel Discussion (Misc queries)	3	October 30th 08 11:15 PM
trimming	RobcPettit[_2_]	Excel Programming	2	July 23rd 06 08:22 PM
Trimming Data	Terry Bennett	Excel Worksheet Functions	4	July 17th 06 02:57 PM
IP Trimming	Josh	Excel Discussion (Misc queries)	1	June 16th 06 04:34 PM
Trimming a cell down to 256 Characters	method373	Excel Discussion (Misc queries)	2	February 12th 06 02:59 PM

All times are GMT +1. The time now is 05:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us