How do I delete a space at the end of an amount or text
 

How do I delete a space at the end of an amount or text?

How do I delete a space at the end of an amount or text
 

You could do this:

=LEFT(A1,LEN(A1)-1)

assuming the data is in A1. This will return a text value - if you
want a number then do this:

=--LEFT(A1,LEN(A1)-1)

Hope this helps.

Pete

On Jun 2, 9:05*am, Maureen wrote:
How do I delete a space at the end of an amount or text?

How do I delete a space at the end of an amount or text
 

If that is a space the below will do. Also note all double spaces within the
text also will be trimmed to a single space.

=TRIM(A1)

Still you see a character after text; then probably it may not be a space.
Check that using the below formula..and replace the character using
SUBSTITUTE()
=CODE(RIGHT(A1,1))


--
Jacob (MVP - Excel)


"Maureen" wrote:

How do I delete a space at the end of an amount or text?

Remove Spaces
 

Following formula would be able to remove spaces from words in Excel,
=REPLACE(A1,LEN(A1),1,"")



Jacob Skaria wrote:

If that is a space the below will do.
02-Jun-10

If that is a space the below will do. Also note all double spaces within the
text also will be trimmed to a single space.

=TRIM(A1)

Still you see a character after text; then probably it may not be a space.
Check that using the below formula..and replace the character using
SUBSTITUTE()
=CODE(RIGHT(A1,1))


--
Jacob (MVP - Excel)


"Maureen" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials...rk-40-and.aspx

Remove Spaces
 

Are you sure it will "remove spaces". That will only remove one space from
the end.

--
Jacob (MVP - Excel)


"Parag Satpute" wrote:

Following formula would be able to remove spaces from words in Excel,
=REPLACE(A1,LEN(A1),1,"")



Jacob Skaria wrote:

If that is a space the below will do.
02-Jun-10

If that is a space the below will do. Also note all double spaces within the
text also will be trimmed to a single space.

=TRIM(A1)

Still you see a character after text; then probably it may not be a space.
Check that using the below formula..and replace the character using
SUBSTITUTE()
=CODE(RIGHT(A1,1))


--
Jacob (MVP - Excel)


"Maureen" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials...rk-40-and.aspx
.

Remove Spaces
 

Oops..I notice now that the OP needs only 1 space to be removed which could
be achieved either using LEFT() or MID() or REPLACE()....

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

Are you sure it will "remove spaces". That will only remove one space from
the end.

--
Jacob (MVP - Excel)


"Parag Satpute" wrote:

Following formula would be able to remove spaces from words in Excel,
=REPLACE(A1,LEN(A1),1,"")



Jacob Skaria wrote:

If that is a space the below will do.
02-Jun-10

If that is a space the below will do. Also note all double spaces within the
text also will be trimmed to a single space.

=TRIM(A1)

Still you see a character after text; then probably it may not be a space.
Check that using the below formula..and replace the character using
SUBSTITUTE()
=CODE(RIGHT(A1,1))


--
Jacob (MVP - Excel)


"Maureen" wrote:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials...rk-40-and.aspx
.