Hi all,
I've got a list of 3 value in a column (It-it_lng, EN-en_lng, DE-DE_lng). The single cell doesn't contain just these values but other value, example: It-it_lng var1, It-it_lng var2, It-it_lng var3)
I need to show in a separate column a value an associated value, for each cell that contain IT-IT_lng, I need to show IT, for each EN-en_lng, EN and for each DE-DE_lng, DE).
This is the desired output.
<tbody>
</tbody>
I tried something like:
=IF(A1="*IT-IT_lng*","IT","")&IF(A1="*en-en_lng*","EN","")&IF(A1="*de-de_lng*","de","")
I've used "*value*" because I need to get all the cells that contain a value with hundreds of different variations.
But this formula doesn't work. Do you have any guess how can I implement this formula?
Thanks
I've got a list of 3 value in a column (It-it_lng, EN-en_lng, DE-DE_lng). The single cell doesn't contain just these values but other value, example: It-it_lng var1, It-it_lng var2, It-it_lng var3)
I need to show in a separate column a value an associated value, for each cell that contain IT-IT_lng, I need to show IT, for each EN-en_lng, EN and for each DE-DE_lng, DE).
This is the desired output.
It-it_lng var1 | IT |
It-it_lng var2 | IT |
En-EN_lng var1 | EN |
De-de_lng var1 | DE |
It-it_lng var3 | IT |
de-de_lng var2 | DE |
<tbody>
</tbody>
I tried something like:
=IF(A1="*IT-IT_lng*","IT","")&IF(A1="*en-en_lng*","EN","")&IF(A1="*de-de_lng*","de","")
I've used "*value*" because I need to get all the cells that contain a value with hundreds of different variations.
But this formula doesn't work. Do you have any guess how can I implement this formula?
Thanks