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

slapelu

New Member
Joined
Jul 18, 2018
Messages
1
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

nemmi69

Active Member
Joined
Mar 15, 2012
Messages
482
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
will you be using VBa?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,448
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
Maybe something like
Code:
Sub Filter4()
Range("A1").AutoFilter 1, "???p*"
ActiveSheet.AutoFilter.Range.Copy Range("D1")
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,114,528
Messages
5,548,570
Members
410,851
Latest member
glowe2020
Top