View original (French)

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

Solved
Mika_8 Posted messages 22 Status Membre -  
Mika_8 Posted messages 22 Status Membre -
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 réponses

Réponse 1 / 2
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
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