Thread: Remove the last letter from a string!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
  
Posts: 184
Default Remove the last letter from a string!
Hi,
cell A1=qwerty
=left(a1, len(a1)-1)

arno

Mannyluk wrote:
Hi,

Can anyone give me a quick answer as to how I remove the last letter
from a string?

qwerty = qwert

Cheers

Manny
Reply With QuoteReply With Quote