Re: how can I eliminate the last character of a cell?

Giganews Newsgroups
Subject: Re: how can I eliminate the last character of a cell?
Posted by:  Dave Peterson (peters…@verizonXSPAM.net)
Date: Wed, 03 May 2006

If it's exactly one character to remove:
=left(a1,len(a1)-1)

If you wanted to get rid of all the leading/trailing/multiple embedded spaces:
=trim(a1)

If you wanted to get rid of all the spaces:
=substitute(a1," ","")

brantty wrote:
>
> I have a database that was imported.  Each cell in column A has the data and
> a space added at the end.  I need a formula to create a new column with the
> data from Column A without the additional space.
>
> EX.  Presently I have [AAA12345 ]
> I would like to show [AAA122345]

--

Dave Peterson

Replies

None

In response to

how can I eliminate the last character of a cell? posted by brantty on Wed, 3 May 2006