Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
Is it possible to Clean up the whole sheet at once. i.e Apply TRIM & CLEAN function to all cells to get rid of obious mess. Also to Clean are internal spaces i.e Some cells might have more then one space beween the values e.g "Joe Doe Bill" to make it "Joe Doe Bill" with one space only Thanks you guys James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cleaning numbers | Excel Discussion (Misc queries) | |||
Excel Cleaning | Excel Discussion (Misc queries) | |||
Help with cleaning up a workbook. | Excel Discussion (Misc queries) | |||
Cleaning Data | Excel Discussion (Misc queries) | |||
Spreadsheet cleaning | Excel Discussion (Misc queries) |