If a cell starts with cz then...
Lali
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello!
A question that might seem silly but isn't working for me:
I would like to indicate a country based on the first two characters of cell E28:
If E28 starts with "cz", then indicate "Czech Republic"; otherwise, indicate "China".
I had written this:
=IF(LEFT(E28, 2)="cz", "Czech Republic", "China")
but it doesn't work!
Thank you for your help!!
A question that might seem silly but isn't working for me:
I would like to indicate a country based on the first two characters of cell E28:
If E28 starts with "cz", then indicate "Czech Republic"; otherwise, indicate "China".
I had written this:
=IF(LEFT(E28, 2)="cz", "Czech Republic", "China")
but it doesn't work!
Thank you for your help!!
