View original (French)

Google Sheets IF cell... starts with... then Function ...

Solved
Mika_8 Posted messages 22 Status Member -  
Mika_8 Posted messages 22 Status Member -
Hello,

I am looking to do this on Google Sheets:

https://gyazo.com/298361dac144b4db13238b8e48890a87

Feel free to ask if you need more details.

Thank you very much!

2 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    =IF(LEFT(A1,3)="bgs",REPLACE(A1,7,5," "),IF(LEFT(A1,2)="br",REPLACE(A1,5,5," "),IF(
    LEFT(A1,2)="sw",REPLACE(A1,6,5," "),IF(LEFT(A1,3)="cos",REPLACE(A1,... ))))
    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0