I IanT Registered User. Local time Today, 09:48 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 Today, 02:48 Joined Jul 2, 2005 Messages 13,824 Sep 30, 2005 #2 Look up the Replace() function in VBA help.
