I want to get data from the text found in 2.. In 1. Is the data I have available and in 3. You will find the wanted result.

1. I have the following information available

2. I am getting this text from scraping: BevestigingswijzeKlembevestigingKleurWitSoorthekSpijlenhek

3. I want this as a result by using a function in Google Sheets.

Thank you in advance!

CodePudding user response：

You could accomplish this with an Apps Script

Reference:

• Custom Functions in Google Sheets