Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Reference : https://www.extendoffice.com/documents/excel/3659-excel-extract-first-two-words.html
- First 5 Word Copy From Another Cell in ExcelSheet Formula
- A2 is Copy Data From Cell
- 4 is Word Count
- =TRIM(LEFT(A2, FIND("^",SUBSTITUTE(A2, " ", "^",4)&"^")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
