Macro is not returning Numeric values and text

[AB33]

I posted this thread last week-end and seem to got reply from Andrew, but since I have been struggling to open this site, my thread has now disappeared from the site. I am not even sure if I can post this thread now. When I click the "Suit New Thread" button, the site hungs up, and the admin staff appear to ignore my plea.

The macro is meant to get numeric and text values on Columns "B and C" respectively. I do not know what is missing from the macro. Please see attached sheet with Macro. Please help.

[Leith Ross]

Hello AB33,

If I understand you correctly, the macro should split the text and numbers from the data in column "A" with text in column "B" and numbers in column "C". The macro below will do that and has been added to the attached workbook.

Please Login or Register  to view this content.

[AB33]

Leith!
Thank you very much! Yes, you are right and macro is great. I am trying to learn scripts and this macro will keep me on the right truck. I spent about an hour to come up with my macro and woud like to know what is missing. Could you please tell me (If you know) why my macro is no working.
Thanks again!

[AB33]

Seems to not have any luck today.