Clean and Trim

**tl7410** · 11-02-2009, 02:20 PM

Regards: http://www.excelforum.com/excel-prog...g-a-macro.html

This is very handy, but I am getting a #VALUE! for character strings longer than 256. I do not understand why, but is there a way around this?

**shg** · 11-02-2009, 02:59 PM

Evaluate will only operate on the first 256 characters.

Please Login or Register  to view this content.

**tl7410** · 11-02-2009, 03:00 PM

Awesome! With 10K rows and columns through AA, there are too many places that the previous macro could return a #VALUE!. Thanks for the quick reply.

**DonkeyOte** · 11-02-2009, 03:03 PM

tl7410,

Welcome to the Board.

Unfortunately your first post did not comply with one of rules of the Forum, namely, Rule 2:

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

I have on this occasion moved your question and all subsequent posts to this new thread. Going forward please ensure you post into threads appropriately.

Thanks in advance for your co-operation.