Getting the value of a cell with a specific character in the 4 spot of the value

[slapelu]

Hi,

I am looking to be able to extract the value of each cell which has a "p" in the 4th spot of a cell.
for example I want to populate a column from the below,

r1pp12345
r2p312345
r3pp34125
p3rp12345

I would get a column with
r1pp12345
r3pp34125
p3rp12345

Any help would be great thanks

Scott

 

[nemmi69]

will you be using VBa?

 

[Fluff]

Hi & welcome to MrExcel.
Maybe something like

Sub Filter4()
Range("A1").AutoFilter 1, "???p*"
ActiveSheet.AutoFilter.Range.Copy Range("D1")
End Sub