Getting partial characters from a cell

[jojo777]

Hi, I am trying to get all the characters on the left side of a cell excluding the last 6 values. The example is 10600V40329. I know I can use =LEFT(A1,5), but because I have thousand of these and they have variable character lengths, I am looking for a formula that will subtract just the last 6 digits all the way down. Your help is greatly appreciated, this is my first time on this site. Thanks.

 

[Luke M]

Welcome to the forum!

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


Note that this will throw an error if text is less than 6 characters long.

 

[jojo777]

Thank you! Talk about instant gratification, that worked perfectly, the check is in the mail!

 

[Luke M]

Sweet! =)