Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove non-printing characters
I'm having trouble working with apperently empty cells in a
spreadsheet which has data pasted from a large Word document. Some cells only look empty. I tried Clean which doesn't work completetly. I don't want to try Trim as it will replace any double spaces etc with single spaces. Using Code on one cell I get 32, telling there is a space in the cell, (other "empty" cells might have other Codes.) Is there any simple Macros I can use to delete the contents of apperently empty cells. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove all characters before a certain one | Excel Discussion (Misc queries) | |||
Remove characters | Excel Discussion (Misc queries) | |||
Remove last 10 characters | Excel Discussion (Misc queries) | |||
Remove first few characters | Excel Worksheet Functions | |||
I need to remove characters ... | Excel Discussion (Misc queries) |