filter specific number in a text string

[samshan143]

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

<tbody>
</tbody>

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

 

[Aladin Akyurek]

I would consider writing such a macro... if I understood exactly what the OP wanted. I am not sure if the number he wants to filter on can be at the beginning or end of the text... or if the spaces are real spaces... or whether other punctuations can be next to the number (for example, is the 403 in ABC(403)DEF considered standalone or not?)... etc.

How about running the formula I suggested from within the macro?