Extraction from srting

[RajatRehria]

Hi guys, i want to extract first 4 words from a column using formula tool, kindly help. Thanks.

Input:

ABC Investment fund Ltd.

XYZ Corporate fund private LLC

Gold Mine fund (New) pvt. Ltd

Desired output:

ABC Investment fund

XYZ Corporate fund

Gold Mine fund

[DataNath · Accepted solution]

Hey @RajatRehria, there's a bunch of ways to do this - here's a few I can think of immediately:

[RajatRehria]

Many thanks @DataNath for the solutions