Create 2 macros in Excel 2010

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

| | 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 ? |

Архітектура ПЗ

ID Проекту: #3707848

Про проект

2 заявок(-ки) Дистанційний проект Остання активність Nov 20, 2011

Доручено:

praveenmar

See private message.

$42.5 USD за 1 день
(2 відгуків(-и))
1.8

2 фрілансерів(-и) готові виконати цю роботу у середньому за $39

anumitru

See private message.

$35.7 USD за 1 день
(0 відгуків(и))
0.0