Delete Characters

[maxmangion]

i have a series of strings and i would like to delete the last 4 characters in each string. Which function should i use to achieve this please ?

Thanks

 

[___]

i have a series of strings and i would like to delete the last 4 characters in each string. Which function should i use to achieve this please ?

Thanks

=LEFT(A1,LEN(A1)-4)

With A1 being the cell with the string.

 

[maxmangion]

Thank you for your reply.