Thread: How do I delete a space at the end of an amount or text
View Single Post
  #3  
Old June 2nd, 2010, 09:49 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
  
Posts: 5,952
Default 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?