kradclayton
New Member
- Joined
- Oct 2, 2020
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi All,
I have to do some VLOOKUP formulas and need to isolate words that I can match between two workbooks.
I am using the below formula to isolate the first word in the cell - example "Camelot Cement Wallpaper"
=LEFT(B2,FIND(" ",B2)-1)
I am left with "Camelot"
Which is working great, but I do have some instances where in the cell B2 there is only one word and so it returns a #VALUE! - is there an IF formula I can use to ignore cells that only have one word, or to keep that one word somehow?
Thanks
I have to do some VLOOKUP formulas and need to isolate words that I can match between two workbooks.
I am using the below formula to isolate the first word in the cell - example "Camelot Cement Wallpaper"
=LEFT(B2,FIND(" ",B2)-1)
I am left with "Camelot"
Which is working great, but I do have some instances where in the cell B2 there is only one word and so it returns a #VALUE! - is there an IF formula I can use to ignore cells that only have one word, or to keep that one word somehow?
Thanks