View Single Post
  #4   Report Post  
Mangus Pyke
 
Posts: n/a
Default

On Sun, 17 Jul 2005 01:06:30 +0100, "Alan"
wrote:

Try using a helper column, If your data were in column A, in column B enter
=LEFT(A1,1)
and drag down to the end of your data list in column A, then sort by column
B
Regards,
Alan.
"Mr_Sparkly" wrote in message
...
I am trying to filter a list of names using only the first letter. How do I
go about setting this up?




Did he mean sort? He said filter..

(Actually a serious question..)

MP
--
"Learning is a behavior that results from consequences."
B.F. Skinner