error clean spaces formula

[Manolocs]

Hello, for some reason this formula clean one space only in the cell, I have to use the formula several times to get ride of all spaces in the cel . Can someone help me? Thanks in advance....

=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))

 

[Caribeiro77]

Yes... I manually remove one space in cell A2 A4 and A9 to test it and bellow there's a screenshot of what i got:

[/URL][/IMG]

 

[Caribeiro77]

Awesome Shg.....sometimes i realise that there's still a long way to me, to reach some of the real guru's technique to solve this kind of (simple)problems...

 

[shg]

deleted -- will re-post

 

[shg]

Trying again:

I have a simple form with some code behind it in Personal that I use for showing cell contents. The needed files are in a zip at https://app.box.com/s/gfo2l90kenhcnj3vjjx1bi0qpy6m85g7. The zip includes a ReadMe, copied below.

1. Grab the other three files from this zip into a directory or onto your desktop.

2. Drag xlEntryPointCSB.bas into the VBA Project of Personal or the workbook of your choice.

3. Drag frmShowBinary.frm into the same project. It will get what it needs from frmShowBinary.frx automatically.

Then you can delete all three files.

Back in Excel, do Ctrl+Shift+B (mentally attached as Conveniently Show Binary) to show the cell's contents.

 

[Manolocs]

@shg I will try. Cheers.

 

[shg]

You're welcome.