truncate text from right

[roduenas]

I have strings of text that read as;

006B_A1_001_C.mov

006ZZ_A1a_001_A.mov

I need to remove the last 6 letters from the right so that the calculation reads;

006B_A1_001

006ZZ_A1a_001

Anyone?

Edited March 9, 2009 by Guest

[comment]

Try:

Left ( text ; Length ( text ) - 6 )

[roduenas]

Wonderful. Thanks so much. O.