is there an easy way to sort data a-z ignoring space, comma etc Steve
D David McRitchie Feb 27, 2006 #2 Hi Steve, Create a helper column and subsume the characters you don't want. Excel has a nesting level of 7 for worksheet functions. =SUBSTITUTE(SUBSTITUTE(A1,",","")," ","") and use the fill handle to copy the formula down http://www.mvps.org/dmcritchie/excel/fillhand.htm If you were replacing letters SUBSTITUTE is case sensitive, additional code and information in http://www.mvps.org/dmcritchie/excel/strings.htm
Hi Steve, Create a helper column and subsume the characters you don't want. Excel has a nesting level of 7 for worksheet functions. =SUBSTITUTE(SUBSTITUTE(A1,",","")," ","") and use the fill handle to copy the formula down http://www.mvps.org/dmcritchie/excel/fillhand.htm If you were replacing letters SUBSTITUTE is case sensitive, additional code and information in http://www.mvps.org/dmcritchie/excel/strings.htm
