software

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]

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,quot; quot;,quot;quot;)brantty wrote:
gt;
gt; I have a database that was imported. Each cell in column A has the data and
gt; a space added at the end. I need a formula to create a new column with the
gt; data from Column A without the additional space.
gt;
gt; EX. Presently I have [AAA12345 ]
gt; I would like to show [AAA122345]

--

Dave Peterson