Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to clear cells of no value
Dim cell As Range
For Each cell In Selection cell.Value = Trim(cell.Value) Next cell -- --- HTH Bob (change the xxxx to gmail if mailing direct) "justme" wrote in message ... Hi, I need a macro to find cells where the whole cell contains only a space/spaces, and/or punctuation and replace with nothing. I need to leave ditto marks (") alone, however, because I do have to deal with those in another way. Basically, a macro to set cell value to null if it does not contain any capital or lower case alpha characters or numbers. It won't let me use "Not Like "*[A-Z]*"...etc." ? Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to clear cells of no value
LOL Can't believe it was just TRIM!
Thanks so very much, Bob.! :):):):):):):) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to clear contents of certain cells | Excel Discussion (Misc queries) | |||
clear unlocked cells macro help please | Excel Worksheet Functions | |||
clear cells macro | Excel Discussion (Misc queries) | |||
macro to clear cells | Excel Discussion (Misc queries) | |||
Macro to clear cells | Excel Discussion (Misc queries) |