View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TiffanyD. TiffanyD. is offline
external usenet poster
 
Posts: 1
Default FInding Duplacates & correcting addresses automatically

I have a 28,000 Contact workbook that I need to clean up before inputing into
a new CRM.
I need to know if I can program the Excel workbook to somehow clean it up
for me.
Take a word out of all caps, Correct some spelling errors, find duplacates
etc.
I am really new at Excel and my job, so it's my job to figure this out and I
really need HELP.
Anybody can give me some idea's I would truly be grateful.
Thank You,
Tiffany D.