How do I filter names using only the first letter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to filter a list of names using only the first letter. How do I
go about setting this up?
 
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.
 
I am trying to filter a list of names using only the first letter. How do I
go about setting this up?
Click to expand...

Turn on your filter and set it to equal a* (if the letter you want to
filter is "a").

You can also, depending on version of Excel, select "Begins with"
instead of "Equals" in the filter criteria and use the first letter.

The asterisk is a wildcard.
 
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.
Click to expand...


Did he mean sort? He said filter..

(Actually a serious question..)

MP
 
He did indeed, error on my part. Doesn't really make any difference though,
Filter by column B, not sort by column B
Regards,
Alan.
 
He did indeed, error on my part. Doesn't really make any difference though,
Filter by column B, not sort by column B
Regards,
Alan.
Click to expand...

Cool.. he can also use wildcards in his filter or "Begins with" and
skip the whole helper column then.

Thanks,
MP-
 
Could do yes, and your advice is valid.
What I think is useful about using a helper column is that once its there,
it will show all the first letters of the column it refers to and therefore
be available for multiple filtering operations without the need to keep
selecting 'Custom' in the filter and entering filter criteria,
Regards,
Alan.
 
Could do yes, and your advice is valid.
What I think is useful about using a helper column is that once its there,
it will show all the first letters of the column it refers to and therefore
be available for multiple filtering operations without the need to keep
selecting 'Custom' in the filter and entering filter criteria,
Click to expand...

Certainly wouldn't argue with that.. I tend to work on the assumption
that adding columns when not necessary is a nice thing to avoid. I'm
probably a little closed-minded about this as a result of the fact
that I usually work with data extracts, and so I'm dealing with a
large number of columns.

Have a great weekend-

Mangus-
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
How do I keep the first letter of each word in that column. 3
How to use LEN & LEFT on last name to show only 3 letters 4
Filtering on upper/lowercase letters 2
Advanced Filter Question 14
Pick List + Alphabetical Skip To or Auto Complete 2

Back
Top