Excel: filter specific number in a text string


Hi, I want to filter a specific number in a series of column, presently I tried to filter using CONTAINS but it also shows result numbers prefixed or suffixed alongwith the filtered numbers. Let me explain with an example. suppose i want to filter 403 in following column

abc 403 xyz
def 60403 hij
ccc 12345 ffg
in above if i want to filter only 403 and if i use filter using CONTAINS 403, then the result will show both the columns i.e. one with 403 and also 60403. is there any way where if i use contain filter for 403 it should show filtered result of 403 only and NOT 60403 or like 4030 etc. please assist. regds


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of February 18, 2014.


For more resources for Microsoft Excel