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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

nemmi69

Active Member
Joined
Mar 15, 2012
Messages
459
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
46,644
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,109,498
Messages
5,529,216
Members
409,857
Latest member
KailuaTown
Top