| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
| trailing spaces | Excel Worksheet Functions | |||
| Excel 2002 : How to remove trailing spaces ? | Excel Discussion (Misc queries) | |||
| REMOVING TRAILING SPACES | Excel Discussion (Misc queries) | |||
| How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
