| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a letter to the start of each cell | Excel Worksheet Functions | |||
| In excel, how do we pull the first letter from words in a sentence | Excel Worksheet Functions | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Linear Mode
