Thread: i want to delete last 3 words of every column

Hi guys hope you are doing well

Guys i am using office excel 2010, and i want to delete last 3 words of every column. like,

Column A

Row 1:- abc-def-gh
Row 2:- abcde-fghija-lm


and i want it to solve and the result will be like this

Column A

Row 1:- abc-def
Row 2:- abcde-fghija

it says that last 3 words delete form every cell are removed
any idea... waiting for your reply

Hello Faddies, welcome to the forum.

It appears you want to remove the last three characters from each cell in a column, not the last three words. Correct me if I'm wrong. To remove the last 3 characters from cell A2 using a formula in B2:

=LEFT(A2,LEN(A2)-3)

Fill that formula down column B for as many entries as you have in column A.