| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find cells with a space at the end
Thanks for all those answers!
"Gary''s Student" wrote in message ... Try this small macro: Sub blankremover() For Each r In ActiveSheet.UsedRange v = r.Value If Right(v, 1) = " " Then r.Value = Left(v, Len(v) - 1) End If Next End Sub -- Gary''s Student - gsnu201001 "Alain Dekker" wrote: 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
