How to extract the first letter of several words in a column

[NathalieB]

Hello

I have a column with one or two words. I would like to get the 2 first letters of each word.

Example

Column Entité : Complexe Paradis
Column Sigle : CoPa

or
Column Entité : Lightheway
Column Sigle : Li

If I use the MID function, I only get the first word letters.

Thanks in advance

[fsa]

Hello Nathalie,

welcome to the SeaTable Forum!

You can use the following formula:

if(
    find(" ", {Name}) > 0,
    concatenate(left({Name}, 2), left(mid({Name}, find(" ", {Name}) + 1, len({Name})), 2)),
    left({Name}, 2)
)

[NathalieB]

@fsa

if(
    find(" ", {Name}) > 0,
    concatenate(left({Name}, 2), left(mid({Name}, find(" ", {Name}) + 1, len({Name})), 2)),
    left({Name}, 2)
)

Wonderfull, it works fine.

Thanks you very much. I tried the concatenate function, but I was very wrong with my formula.

Thanks again and have a nice day !