is there an easy way to sort data a-z ignoring space, comma etc
Steve
is there an easy way to sort data a-z ignoring space, comma etc
Steve
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"stevebicks" <[email protected]> wrote ...
>
> is there an easy way to sort data a-z ignoring space, comma etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks