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
Solved! Go to Solution.
Many thanks @DataNath for the solutions