if your text is in A1 and you want tyour result in B1, put this in Cell B1

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

"drob2528" wrote:

I need to copy varying lenght text strings to new cells but I need to drop
the last 6 right most characters of each string.

Any ideas?

I am working in Excel 2003 SP3

Thanks in advance for any help