Need a Macro?
 

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

Need a Macro?
 

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



"Mythikal" schreef
in bericht ...

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

Need a Macro?
 

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.


--
Mythikal
------------------------------------------------------------------------
Mythikal's Profile: http://www.excelforum.com/member.php...o&userid=36680
View this thread: http://www.excelforum.com/showthread...hreadid=564166

Need a Macro?
 

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

Svend

"Mythikal" skrev i
en meddelelse ...

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

Need a Macro?
 

Delete leading and trailing spaces.


Cheers man just what i was looking for

--
Mythika
-----------------------------------------------------------------------
Mythikal's Profile: http://www.excelforum.com/member.php...fo&userid=3668
View this thread: http://www.excelforum.com/showthread.php?threadid=56416

Need a Macro?
 

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

Svend

"Mythikal" skrev i
en meddelelse ...

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

Need a Macro?
 

TRIM function or CLEAN function -- both are text functions

"Svend" wrote in message
...
yes - I have been using thi utility for years - and can't live without
now.... :;)

Svend

"Mythikal" skrev i
en meddelelse
...

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