View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default sorting using a second word in a cell

You would need to create a help column then use a formula to extract that
second word, then sort by the help column


--

Regards,

Peo Sjoblom





"sonia" wrote in message
...
I was just wondering if there is a way to sort columns by using the second
word in a cell? and if so how would i go about it?