Extract all but x number of characters

[ketedford]

Please help -
I need to extract a cell and have the new cell contain everything but the last 8 characters.

I appreciate any and all solutions.

Thanks

[jasoncw]

This formula should work for you:

=IF(LEN(A1)<9,"",LEFT(A1,LEN(A1)-8))

The above will return all characters except the 8 right characters. It will return nothing if the length of the cell is 8 or less characters.

HTH

Jason

[ketedford]

Thanks for an immediate response. I've been working about 2 hours on this one.

[daddylonglegs]

Here's another way

=LEFT(A1,MAX(0,LEN(A1)-8))