I IanT Registered User. Local time Today, 00:32 Joined Nov 30, 2001 Messages 191 Sep 30, 2005 #1 Hi I have data which has & ' with-in the data. How can I remove these! Thanks in advance.
RuralGuy AWF VIP Local time Yesterday, 17:32 Joined Jul 2, 2005 Messages 13,824 Sep 30, 2005 #2 Look up the Replace() function in VBA help.
