View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m tim m is offline
external usenet poster
 
Posts: 430
Default sorting a column with numbers and text

How do you want them sorted? (as in by what part of the cell?) "Ford35"
wrote:

I am trying to sort a column with numbers and text eg;
.75-2-mbv-167
.75-2-mbv-168
2-2-mdv-004
1.5-1-mbfv-002
1.5-1-mbfv-001
these are identification tag's for valves.
I have over 2700 items with differnent code numbers!
I need help !
--
Ford35