ExcelBanter - Need to Pull Those that Start with Letter P

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need to Pull Those that Start with Letter P (https://www.excelbanter.com/excel-worksheet-functions/238358-need-pull-those-start-letter-p.html)

Toria

Need to Pull Those that Start with Letter P

Hello,

I have column that has plan names. I need a formula that will pull only
those plan names that start with the letter P into column B.

Thank you!

RagDyeR

Need to Pull Those that Start with Letter P

=If(Left(A1)="P",A1,"")

Copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Toria" wrote in message
...
Hello,

I have column that has plan names. I need a formula that will pull only
those plan names that start with the letter P into column B.

Thank you!

Toria

Need to Pull Those that Start with Letter P

Thank you!!!!!!!! It worked perfectly!

"RagDyeR" wrote:

=If(Left(A1)="P",A1,"")

Copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Toria" wrote in message
...
Hello,

I have column that has plan names. I need a formula that will pull only
those plan names that start with the letter P into column B.

Thank you!

All times are GMT +1. The time now is 04:20 PM.