-
Solved: Word to excel & 'clip'
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
-
Post a short example. Delete all but say 5 rows.
-
Its Ok - I will just build a macro that deleted rows after the range I want to keep
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules