Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel