G Guest Nov 1, 2004 #1 Hi I try to use trim in Excel but ..... What can i use instead ?? Best regards Alvin
G Gord Dibben Nov 1, 2004 #3 Alvin What are you looking to do that TRIM won't do? HTML has a habit of leaving junk in cells. Non-breaking spaces for one. To clean up the junk you can use TRIM and CLEAN and Edit>Replace if you know which character it is. Download Chip Pearson's CELLVIEW add-in from http://www.cpearson.com/excel/CellView.htm Load through Tools>Add-ins. Select the data and Chip's add-in will show you what the characters are. If carriage returns you may be able to Replace them using ALT + 0010 or 0013 Most likely David McRitchie's TRIMALL macro will be of greatest assistance. Cleans up what TRIM and CLEAN miss. http://www.mvps.org/dmcritchie/excel/join.htm#trimall Gord Dibben Excel MVP
Alvin What are you looking to do that TRIM won't do? HTML has a habit of leaving junk in cells. Non-breaking spaces for one. To clean up the junk you can use TRIM and CLEAN and Edit>Replace if you know which character it is. Download Chip Pearson's CELLVIEW add-in from http://www.cpearson.com/excel/CellView.htm Load through Tools>Add-ins. Select the data and Chip's add-in will show you what the characters are. If carriage returns you may be able to Replace them using ALT + 0010 or 0013 Most likely David McRitchie's TRIMALL macro will be of greatest assistance. Cleans up what TRIM and CLEAN miss. http://www.mvps.org/dmcritchie/excel/join.htm#trimall Gord Dibben Excel MVP
G Guest Nov 3, 2004 #4 Sorry I use a Danish version of Excel there fore trim dosn work I have find the danish code insted. best regards alvin "Frank Kabel" skrev:
Sorry I use a Danish version of Excel there fore trim dosn work I have find the danish code insted. best regards alvin "Frank Kabel" skrev:
