I have exported my .PST file from Outlook as a .csv file and then I need to
clean up all the extra characters. I have a code for "Clean Me."
It is:
Sub CleanMe()
Dim cel As Range
Application.ScreenUpdating = False
For Each cel In ActiveSheet.UsedRange
cel = Application.Clean(cel) (Use the tab key to indent this line of the
code.)
Next cel
Application.ScreenUpdating = True
End Sub
But after i run it, it gives a "#VALUE!" error in some of the fields. All of
the fields that get messed up are the fields from the "Notes section" in
outlook. All of the notes fields don't mess up, but a lot do.
Please Help!
Bookmarks