Thread: detect trailing spaces in an excel document
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default detect trailing spaces in an excel document
In addition to David's reply...............possibly =RIGHT(A1)=CHAR(160)
for the html non-breaking spaces if you have those.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 17:14:55 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

=RIGHT(A1)=" " will return TRUE if you have trailing spaces, and FALSE if
you don't.
You could use that formula as a conditional formatting condition, if you
wish.

Reply With QuoteReply With Quote