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


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


Column Entité : Complexe Paradis
Column Sigle : CoPa

Column Entité : Lightheway
Column Sigle : Li

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

Thanks in advance

Hello Nathalie,

welcome to the SeaTable Forum!

You can use the following formula:

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

1 Like

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 ! :wink:

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.