| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells with a space at the end
How do I find all cells (with text in it) that ends with a space ie.
"This is some text " which I either want to highlight or automatically fix to: "This is some text" I'm using Excel 97. I have tried to turn on showing special character like you can in Word (where a space appears as a dot), but couldn't find that command. The Find command also doesn't help. Many thanks, Alain |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find position number of third space | Excel Worksheet Functions | |||
| Find last space | Excel Worksheet Functions | |||
| Using FIND function to locate space between first and last name | Excel Worksheet Functions | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| Find last space from the right of text | Excel Discussion (Misc queries) | |||
![Alain Dekker[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
