Posted to microsoft.public.excel.misc

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Removing spaces from cells not possible?

On 11 Oct 2006 11:46:10 -0700, "Robert M. Gary" wrote:

Ron Rosenfeld wrote:

Usually that space is CHAR(160) and can be removed using the SUBSTITUTE
function.

Your right. After doing a find replace for 0160 replace with "", it
worked. I can't believe Microsoft hasn't addressed this with =clean()
yet. Isnt' think was =clean is for?

-Robert

I would have thought so.

Glad it worked.
--ron

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
Linking Groups of cells between workbooks	vnacj-joe	Excel Discussion (Misc queries)	4	June 14th 07 05:18 PM
Removing leading/trailing spaces	Chuda	Excel Discussion (Misc queries)	2	September 12th 06 04:20 PM
Spaces in cells	Brian	Excel Worksheet Functions	1	August 2nd 06 06:17 AM
Deleting blank spaces in cells	Mr Gow	Excel Discussion (Misc queries)	4	May 17th 06 02:06 PM
Removing $$ Reference in cells	Castor	Excel Worksheet Functions	1	August 13th 05 12:36 AM

All times are GMT +1. The time now is 12:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us