Forum Discussion

Anonymous's avatar
Anonymous
Aug 01, 2019

EXCEL: "If cell contains specific letter using LEFT formula then return specific text"

Problem: 25k rows per column and I'm trying to extract different types of product references.  Using =Left(cell;1) I will have 3 different outputs. "E", "F" and "U".   Now what I need to do is ren...
excel
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Aug 01, 2019

Hi Deleted 

 

Try below formula

 

=IF(LEFT(B5,1)="E","1st Text",IF(LEFT(B5,1)="F","2nd Text","3rd Text"))

 

Hope it will help.

Thanks

Tauqeer

  • Anonymous's avatar
    Anonymous
    Aug 02, 2019

    Thank you!

     

    It worked fine, I guess I was overthinking a simple formula

Resources