DELETING THE LAST CHARACTER IN A STRING

[Guest]

HOW DO YOU DELETE THE LAST CHARACTER IN A STRING??

I HAVE SOME ITEM ID AND NEED TO DELETE THE LAST CHARACTER

EXAMPLE: C-1202A NEDD TO MAKE IT C-1202

 

[John Wilson]

John,

Try this:

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

John

 

[Ron de Bruin]

Try this with the string in a1

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

 

[Eva Shanley]

Hi,
this formula will replace the character in the 7th
position (the A) with a blank:
=REPLACE(A1,7,1,"")
HTH.

 

[Dave Peterson]

And see one more reply at your first post for a non-formula approach.