truncate?

@XOR LX,

I don't think I have seen that construction for the MATCH function (match plus 1 in a resulting array of negative numbers and errors) before... I like it! However, I would point out that if the OP has blank cells within his data or if he wants to copy the formula down past the end of his data in anticipation of future additions to the data, you would need to add a trap those blank cells as your formula will generate a #N/A error for them whereas my formula natively outputs the empty text string ("") for blank cells. With that said, if the OP has a sense of some maximum length for the resulting output from the formula, say 99 characters maximum, then your match formula can be shortened to this (again possibly requiring a blank cell trap if the OP's data or usage so needs)...

Formula:

=LEFT(A1,MATCH(1,-MID(A1,ROW($1:$99),1)))