Auto filter

[PL]

I have a column with numbers running from 1- 100, I used custom autofilter to
find all numbers beginning with 1 but it returned only all the empty rows,
why is that so?

Thanks

 

[PJFry]

It has to do with the way that Excel views the numbers. Simply put, 100 is
100 versus a word, say 'dog', which can be broken up into d-o-g. Filter by
the first character of a cell, that cell must be a text value.

Assuming your number column runs from A2 to A101, you can put in a formula
in column B that converts those values to a text. In cell B2 enter:
="&A2 and copy that formula to the end of your range. Then do the filter on
column B and it should work.

Post back with questions.

 

[PL]

Hi

Thanks . But what's the formula to convert numbers into text? I tried ="&A2,
it didn't work.

Thank you

 

[T. Valko]

I tried ="&A2, it didn't work.

Try it with 2 double quotes:

=""&A2

=A2&""