Blog Marco

I was looking at maintaining some excel databases and I needed to delete the first word from every row in a certain column in Microsft Excel. I imagined myself going through every cell and deleting the dratted word but I thought a macro could do that. Better yet there is an excel formula which you can program to get Excel to delete and remove the first word from a cell column/row or even the last word depending on what you need:

Code for deleting the first word in a cell in Excel:

=RIGHT(C2,LEN(C2)-FIND(" ",C2))

Code for deleting the last word in a cell in Excel:

=LEFT(C2,LEN(C1)-2)

General Computing | Have you enjoyed this post? Share it with your friends... »