Autofill with exclusions

[StephenSLR]

Currently in Aus. a lot of new Chinese immigrants are buying units so developers are kowtowing to their tetraphobia by building unit blocks without a fourth floor or floors without the number four same goes with the unit numbers.

See link:

http://www.dailymail.co.uk/news/article-3481168/New-Sydney-apartment-building-deliberately-left-floors-number-four-sounds-similar-death-Chinese.html

I have to create spreasheets without unit numbers that have the number 4 in them, below is an example of the ground floor units:

G.01
G.02
G.03
G.05
G.06
G.07
G.08
G.09
G.10
G.11
G.12
G.13
G.15

etc.

Is there a way to autofill and exclude the number 4 and skip to 5 or would it be easier to get the Aus. govt. to ban Chinese immigration? lol.

s

 

[StephenSLR]

[I got this far but the visible cells also include the first cell 1.01 after step 3]Please be sure you did step 2:copy A1:A800 and paste values.

A-ha, that's the part I missed. lol.

When I paste however, there is only number filters and I don't have the same choice of criteria, there is no 'contains' choice only greater/less than.

s

 

[shaowu459]

it should be text filter there.