Trimming characters from text in MS Excel

Today while working in excel I came upon a situation where I wanted character to be removed from text in excel.

I searched for available options best suitable option was use of LEFT and LEN formulas.

My text was list of number of packets where packets was mentioned along with number of packet and wanted to remove text packets.


For this I used formula

LEFT(A1, LEN(A1)-8)


LEFT formula is used to shows specified number of characters from string of text

LEN formula is used to provide number of characters to retain from original string. This formula evaluates length of a string of characters.

If text you want to retain is at end of string you can use RIGHT formula instead of LEFT