Retrieve first 3 words in a cell
Perfect!
Thank you, Jacob!
"Jacob Skaria" wrote:
Try the below formula
=LEFT(SUBSTITUTE(A1 & " "," ",REPT(" ",255),3),255)
If this post helps click Yes
---------------
Jacob Skaria
"KrispyData" wrote:
There are at least 3 words in each cell?
"Luke M" wrote:
This formula should work, provided there is always at least four words in the
cell:
=LEFT(A2,FIND(" ",A2,FIND(" ",A2,FIND(" ",A2)+1)+1)-1)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"KrispyData" wrote:
I have an address field and I would like to create a formula to retrieve the
first 3 words in the address. How can I do this?
example:
1245 main street suite 10
i would like the result to be:
1245 main street
thanks so much for any help!
|