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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

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,365
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,421
Messages
5,547,823
Members
410,813
Latest member
Vhinzvirgo
Top