How to extract first 20 plus words from text string in google sheet-CodePudding

Home > Blockchain > How to extract first 20 plus words from text string in google sheet

How to extract first 20 plus words from text string in google sheet

Time：09-26

I want to extract first 22 words from a text string in column A in google sheet.

here is a google sheet

CodePudding user response：

If you don't mind to use a custom function here you go:

function GET22WORDS(cell) {
  return cell.match(/\w{3,}/g).slice(0,22).join('\n');
}