Hi, I have data in a column, which precedes by one or more spaces, how do I remove these. thanks
M mike Aug 3, 2004 #1 Hi, I have data in a column, which precedes by one or more spaces, how do I remove these. thanks
F Frank Kabel Aug 3, 2004 #2 Hi one way: =TRIM(A1) Also have a look at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall
J JE McGimpsey Aug 3, 2004 #3 Try David McRitchie's TrimALL macro, especially if the data is pasted in from an external source, like a web page: http://www.mvps.org/dmcritchie/excel/join.htm#trimall
Try David McRitchie's TrimALL macro, especially if the data is pasted in from an external source, like a web page: http://www.mvps.org/dmcritchie/excel/join.htm#trimall
