Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
The CLEAN worksheet function removes all non printable characters, try something like this Sub CarriageRtn() Dim cell As Range For Each cell In Selection cell.Value = Application.WorksheetFunction.Clean(cell.Value) Next cell End Sub Select the problem cells and run the macro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carriage return | Excel Discussion (Misc queries) | |||
Carriage Return Problem | Excel Discussion (Misc queries) | |||
Carriage return during an if statement | Excel Discussion (Misc queries) | |||
Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
Carriage Return | Excel Worksheet Functions |