The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Extract the first 2 letters of each word

posted Jan 24, 2022 12:16:08 AM

Topic Labels: Formulas

0 736 0

Hello,

I’m trying to extract the 2nd letter of each word after a comma but I fail :frowning:

I have :

Hello you, how are you, good

And I looking a formula to have this result :
He_ho_go

Do you have any idea ?

Thanks a lot

0 Replies 0