ExcelBanter - Remove the last letter from a string!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Remove the last letter from a string! (https://www.excelbanter.com/excel-programming/325844-remove-last-letter-string.html)

Mannyluk

Remove the last letter from a string!

Hi,

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

qwerty = qwert

Cheers

Manny

arno

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

All times are GMT +1. The time now is 10:35 PM.