remove / replace a string of digits with nothing

Hello all,

I would appreciate any help with removing the following string from a sheet: semi-colon, hash, four (three, two or even one digit), semi-colon, hash.

for example, change this string:

NA;#154

to look like this:

NA

or this string:

PL;#178;#BY;#22;#CZ;#61;#EE;#73;#LV;#124;#LT;#130;#RU;#185;#SK;#201;#UA;#234

to look like this:

PL;BY;CZ;#EE;LV;LT;RU;SK;UA;

This rule seems constant throughout the entire sheet. In the sample workbook attached, the string to be replaced is contained in row F only, but since the data is imported, the problematic string may be located in some other row. For this reason, it would be very convenient if the solution worked for the entire sheet.

@ex2012:

If you prefer a VBA solution, you can try the attached workbook where "Regular Expressions" method is used to fetch the required data.