Changes to Concatenate Macro

http://www.excelforum.com/excel-prog...ate-macro.html Previous post for original macro created.

Changes:
macro breaks if range A only has one line of data
Can output be placed at ,9 (column H) instead of ,6?
**Can Astricks, dashes be excluded from the concatenate function?
Can the ouptut for the count of the charaters be output to ,10 instead of ,8?
Can the output line populate in ,8 the range from column A without the dash?

Thank you in advance

Please Login or Register  to view this content.

Can the output to ,8 (column H) be the number in Column A without the dashes?
Output current output in ,8 (column H) to be ,9 (Column I)
One additional item. Can you do this same forumulas for the Short text in Column F also?

column A is the same number repeated. Below is an example.

0405-1771
0405-1771
0405-1771
0405-1771

Actually the last request for the short text from column F will just need to populate the last description in the array. No concatenation needed.

I am testing the macro on the Test1 data I attached in the previous thread. http://www.excelforum.com/excel-prog...ate-macro.html

When I do this, I get a Type mistach error.

Could you put the result in Column I. That way both long and short descriptions are in the same column.

Works awesome Thank you so much. I will be able to make a few tweaks now.