Hello everyone,
Would appreciate if you can help me out on the below.
I have a data extract that depicts the company info as this:
Company [1]
Can you let me know how I can delete:
- [
- ]
- Last right space
Right now I'm doing the above manually and then afterwards I have my formula as: =LEFT(B2,FIND(" ",B2,LEN(B2)-1)) but is taking too long
Final value should be:
Company
Thank you for your guidance.
Bookmarks