View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
=LEFT(A1,LEN(A1)-2)

--
Regards
Frank Kabel
Frankfurt, Germany

"Patrick" schrieb im Newsbeitrag
...
I have a column with numbers that are either 3 or 4 characters in

length. I
would Like to delete just the last two characters. Is there an easy

way to do
this?
Thanks