CODEWITHSUNDEEP
excelexcel-formula
Caracks
Caracks

Reputation: 49

Remove last character from first word in excel

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

Upvotes: 1

Views: 140

Answers (2)

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 12008

Try this in A1:

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

It should work like below:

enter image description here

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152660

Use Replace:

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

enter image description here

Upvotes: 4

Related Questions