Copying text to new cell

[drob2528]

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

 

[Dennis]

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

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

 

[Gary''s Student]

For data in column A, in B1 enter:

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

 

[drob2528]

Thanks Dennis, that worked. I knew about LEFT, forgot abot the LEN command.

 

[drob2528]

Thanks "Gary's" Student, that worked. Knew about LEFT, forgot about the LEN
command.