I'd use a helper column that would evaluate to true or false.

If I only cared about the rightmost character, I'd use a formula like:

=ISNumber(-Right(A2,1))

Then drag down and filter by that helper column.

===
If you really wanted to check the last 4 characters to see if they were numeric:
=ISNumber(-Right(A2,4))

Brian17 wrote:

Hi, I have a quesiton about filtering. I have a column that contains entries
such as:
aa1100
bb2200
cc4455
cfd9088
fdaniels
fdr8888
jjones
jsmith
kwilliams

How can I filter the list so I see only the entries that do not contain
numbers? I've tried to figure this out using the "ends with" custom filter
option, but can't get it to look for ending in 4 digits. The data will always
end in 4 digits. Any thoughts on filtering it or using a function?

Thanks!
-Brian

--

Dave Peterson