Copying text to new cell
 

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

Copying text to new cell
 

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

Copying text to new cell
 

For data in column A, in B1 enter:

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


--
Gary''s Student - gsnu200777


"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

Copying text to new cell
 

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

"Dennis" wrote:

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

Copying text to new cell
 

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

"Gary''s Student" wrote:

For data in column A, in B1 enter:

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


--
Gary''s Student - gsnu200777


"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