software

Hi all,

I'm hoping someone out there can help. I've been working with this Excel
file that I believe was imported from an external app. Column A has a bunch
of data along with a whole slew of empty cells. Problem is, they are not
empty. I copied and pasted the column into Word so I could see the invisible
characters, and low and behold, they were many. Some cells had space amp; tab
characters after existing text, others had space characters in the blank
cells. Additionally, the spaces were not all equal. Sometimes it was 15
spaces, sometimes 8, etc. I need to physically remove all these invisible
characters so sorting amp; filtering will work the way it's supposed to.

Reading through the available threads, I couldn't find anything for my
situation. I tried FInd/Replace/ALT 0160 and that didn't work because it
only accounts for one single space. Can't use TRIM since the spaces are
varying in lengths. Does anyone have any suggestions?

Thanks,
Joe


Try the quot;CLEANquot; Function - it will remove all quot;NON-PRINTINGquot; characters,
(i.e. tabs, spaces, etc.).--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=500976CLEAN doesn't remove spaces so you will also have to use TRIM which
removes all spaces except for single spaces that are between other
characters.
Ken JohnsonThank you Ken. This works great

quot;Ken Johnsonquot; wrote:

gt; CLEAN doesn't remove spaces so you will also have to use TRIM which
gt; removes all spaces except for single spaces that are between other
gt; characters.
gt; Ken Johnson
gt;
gt;

Hi Joe,
Great!
Thanks for the feedback.
Ken Johnson