Need a Macro?

[Mythikal]

I'm looking for a Macro that can remove all unwanted space in the cell?

Eg. +lExample ( Space ) l+

That is the cell and the space after "Example" is there and it has been done on about 50% of them and i just need a macro or some help so i can remove all the space without having to go do every single on considering there is about 2877 of the cells and it could take time if i had to.

Thankyou.

Alex.

[moon]

Just use Edit - Search/Replace and replace any space with nothing.



"Mythikal" <[email protected]> schreef
in bericht news:[email protected]...
>
> I'm looking for a Macro that can remove all unwanted space in the cell?
>
> Eg. +lExample ( Space ) l+
>
> That is the cell and the space after "Example" is there and it has
> been done on about 50% of them and i just need a macro or some help so
> i can remove all the space without having to go do every single on
> considering there is about 2877 of the cells and it could take time if
> i had to.
>
> Thankyou.
>
> Alex.
>
>
> --
> Mythikal
> ------------------------------------------------------------------------
> Mythikal's Profile:
> http://www.excelforum.com/member.php...o&userid=36680
> View this thread: http://www.excelforum.com/showthread...hreadid=564166
>

[Mythikal]

Soz, there is no easy way to explain.

there is a code 12343

i am on a different page and i got a formula that gets that number and it shows the price of that product.

The problem is that the formula is looking for 12343 but cant find it because of the person who made the spread sheet pressed space bar like 2 times so it makes 12342-- with the - being just space.

I need something that will get rid of that space.

[Svend]

Hi,
Try to have look on the free program ASAP Utilities.
Can be found at www.asap-utilities.com

Svend

"Mythikal" <[email protected]> skrev i
en meddelelse news:[email protected]...
>
> I'm looking for a Macro that can remove all unwanted space in the cell?
>
> Eg. +lExample ( Space ) l+
>
> That is the cell and the space after "Example" is there and it has
> been done on about 50% of them and i just need a macro or some help so
> i can remove all the space without having to go do every single on
> considering there is about 2877 of the cells and it could take time if
> i had to.
>
> Thankyou.
>
> Alex.
>
>
> --
> Mythikal
> ------------------------------------------------------------------------
> Mythikal's Profile:
> http://www.excelforum.com/member.php...o&userid=36680
> View this thread: http://www.excelforum.com/showthread...hreadid=564166
>

[Mythikal]

Delete leading and trailing spaces.


Cheers man just what i was looking for.

[Svend]

yes - I have been using thi utility for years - and can't live without
now.... :

Svend

"Mythikal" <[email protected]> skrev i
en meddelelse news:[email protected]...
>
> Delete leading and trailing spaces.
>
>
> Cheers man just what i was looking for.
>
>
> --
> Mythikal
> ------------------------------------------------------------------------
> Mythikal's Profile:
> http://www.excelforum.com/member.php...o&userid=36680
> View this thread: http://www.excelforum.com/showthread...hreadid=564166
>

[Sasa Stankovic]

TRIM function or CLEAN function -- both are text functions

"Svend" <[email protected]> wrote in message
news:e%[email protected]...
> yes - I have been using thi utility for years - and can't live without
> now.... :
>
> Svend
>
> "Mythikal" <[email protected]> skrev i
> en meddelelse
> news:[email protected]...
>>
>> Delete leading and trailing spaces.
>>
>>
>> Cheers man just what i was looking for.
>>
>>
>> --
>> Mythikal
>> ------------------------------------------------------------------------
>> Mythikal's Profile:
>> http://www.excelforum.com/member.php...o&userid=36680
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=564166
>>
>
>