Create 2 macros in Excel 2010

| | 1. CleanListColumn(). This removes all non-printing characters and changes all non-printing characters and whitespace to semi-colons. This is to prepare a list of items to go into a CSV file steps -Select Column -CleanListColumn() removes all control characters and spaces and replace with (1) semicolon. -Next it renames the Input column to InputName+"_old" and changes the result column to the InputName name. -In addition, remove any starting or trailing whitespace or control characters 2. CleanBioColumn() This replaces all unicode characters within a bio set of data. The data was pulled from HTML so it needs to be cleaned up. -Select column -CleanBioColumn() replaces/deletes according to the table of actions -Next it renames the Input column to InputName+"_old" and changes the result column to the InputName name. The list of control characters in the macro code needs to be well commented, so they can be added to. some examples (but prefer to have the unicode listed in format of (0xNNNN) ? = delete — = replace with - ?? = replace with ' • = replace with ? |