Remove last character from first word in excel

1
votes

I need to remove the last character from first word in excel.

For example I have the cell B1 with "Teas from Spain" and I need cell A1 to be "Tea from Spain".

Thank you

2
excelexcel-formula
Possible duplicate of Extract substring from this string inside Excel cell - Sandeep Chayapathi

2 Answers

4
votes

Use Replace:

=REPLACE(B1,FIND(" ",B1&" ")-1,1,"")

enter image description here

2
votes

Try this in A1:

=LEFT(B1;FIND(" ";B1)-2)&MID(B1;FIND(" ";B1);999)

It should work like below:

enter image description here