PDA

View Full Version : Solved: Word to excel & 'clip'



Blackie50
09-14-2011, 07:31 AM
Hi there

Wonder if anyone can help with following. Its very much related to the earlier query regarding unique account numbers.

Anyway I have a word document that has 16732 pages with summaries, totals, paragraphs, underlining etc. A number of pages have an account number on a line with customer details below.

I have imported this in to excel and got the account numbers in column A. Thing is there are now 200,000+ rows with a lot of other rubbish thats been brought over from Word.

I would like to get rid of all this without having to delete manually.

Can anyone help with macro to delete the row if col A isn't like/in the following account format - NNNNNNNLN (N = number, L = letter) - not bothered about customer details just need to capture the account numbers and then apply the formula/macro supplied in earlier thread to come up with the actual customer count.

thanks for any help
Jon

Kenneth Hobs
09-14-2011, 08:24 AM
Post a short example. Delete all but say 5 rows.

Blackie50
09-15-2011, 12:35 AM
Its Ok - I will just build a macro that deleted rows after the range I want to keep

thanks