Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have church members who submit Excel 2003 spreadsheets to me with name and
address information in columns A thru E (Name, address, city, state, zip). Some sheets are submitted with either leading or trailing spaces in various cells. I would like a macro that would inspect each cell in every column for leading or trailing spaces and highlight them with a blue background color so that the users can see the spaces when I return the sheets to them. Thanks, Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
removing leading and trailing spaces | Excel Programming | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
Removing leading/trailing spaces | Excel Discussion (Misc queries) | |||
How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
Delete leading or trailing blank spaces in cell - an example | Excel Programming |