| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
