View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sorting W after V

You are sorting in ascending order, right?

And there are no extra leading spaces (or other invisible characters) before the
V or W, right?

fridden wrote:

I am having trouble seperating v from w when sorting.
I e, if I have these two cells:

viktor
wahn

I would like "viktor" to sort before "wahn", but Excel keeps
insisting on sorting wahn first, like it doesnt seperates v from w.

Anybody knows how what I am doing wrong? Or is this the only
way it works?

tia
/Fredrik


--

Dave Peterson