Hello:
Please refer to attached file.
I need VB Code to do following.
Go thru column C and delete non-numeric cells. (Delete "XYZ" and "CENETER")
Go thru Column D and do following
Delete all numeric numbers
Delect "*" character
Truncate cell content to 20 character.
Let me know if you have any questions.
Thanks.
Bookmarks