excel hell

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 .:eeek: ..thanks to the experts out there
 
Last edited by a moderator:

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
to be honest "Lucky",

This more of a rant than a question......questions,

can you post your page with what is there and expected results then we may be able to help
 
Upvote 0
Have you tried doing a find replace for <*> and replacing it with nothing? That should hopefully strip all your HTML out.
 
Upvote 0
Cwatts...i will try that ......Dryver...there was some rant in there for sure..but i also wanted to make clear what i have tried and system capabilities...the questions are 1...removing hidden characters....or copying the the (only text) to start a new workbook....2...column A has email column B has first name...but i do have duplicates and i want to make sure that i remove the that sir or madam in column b and keep first name where i have it...thanks again
Cwatts I will That and let you know ..
again thanks guys
and PS i do not know how to post my page or attach it

Take on the Day
 
Upvote 0
Try copying the hidden characters to a seperate cell..

then use..

=Char(CELL REF HERE)

I had trouble trimming character 160 from txt data I've imported before.

So I then used...

=CLEAN(SUBSTITUTE(A2,CHAR(160),))

which seems to work for me.

Regards


Roger
 
Upvote 0
I removed your email address. We generally tell people not to post their email addresses publicly, as Spammers often patrol public user forums such as this one looking for email addresses to Spam. The best way to share you email address with someone is through a Private Message (PM).
 
Upvote 0
Welcome to the Board!

See the link beneath my sig for how to post shot of your sheet.
 
Upvote 0
Hi all i feel like a real dunce here....thks for the email removal...i will figure out html maker and post page and get back to you..mancemonster i will try those now i am trying to figure out how to apply to entire column...i did say i was a dummy...i should have learned VB long ago.....:(
 
Upvote 0
As to the marco needed I have tried creating a rule without success...
as mentioned i have 2 columns one with email and one for first name..
sometimes i have duplicate in column A and in column B for that duplicate one might the first name and the other has sir or madam... so i want to keep the row with the first name...so i think it would be something like "if duplicate in A and sir or madam is in b then remove that one and keep the one with first name.....again tks all
 
Upvote 0

Forum statistics

Threads
1,224,589
Messages
6,179,744
Members
452,940
Latest member
rootytrip

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top