Hello,
This seems so easy, but I can't get it to work correctly.
If a cell or group of cells contains a product description, and the last word is undesired in all the cells, how would we go about this? I've found this formula to delete the first word:
=RIGHT(A1,LEN(A1)-FIND(" ", A1,1))
before:
This is a test.
after
is a test.
What is desired is:
This is a
Thank you.
This seems so easy, but I can't get it to work correctly.
If a cell or group of cells contains a product description, and the last word is undesired in all the cells, how would we go about this? I've found this formula to delete the first word:
=RIGHT(A1,LEN(A1)-FIND(" ", A1,1))
before:
This is a test.
after
is a test.
What is desired is:
This is a
Thank you.