luckymontrealer
New Member
- Joined
- Apr 10, 2011
- Messages
- 4
ok hello all i am not an expert in excel but not horrible...i have done my research before joining and posting but i have reached my boiling point....so i have a excel text database that has hidden characters i have tried trim clean...~* ~? nothing works....i am pulling my hair out...i have tried add in...removing formats ...OMG...i have 2007 and 2010 on different comp....have quad processor and 6 gigs ram and loads of hard drive space...so hidden characters are on every line...i do not know how to attach file here...also i am looking for a macro that will .....PS i am VB dummy....this is an email database of clients to webinars...i have duplicates in column A but i only want to remove the duplicate that has sir or madam in column B and keep the row that has email address and the first name....first problem is removing what ever stops me from sorting data without the program freezing...OMG i hope this makes sense . ..thanks to the experts out there
Last edited by a moderator: