I'm using an older for of Excel 2000, and it displays all CHR(30) in a column B.  I would like to remove all instances from this file.  I know the value is CHR(30) which is a record separater.   

The newer versions of Excel will not display certain invalid characters in workbooks.

Copy the following line of code (select it and press Ctrl+C).

ActiveSheet.UsedRange.Replace What:=Chr(30), Replacement:="", LookAt:=xlPart

Switch to Excel.

Press Alt+F11 to activate the Visual Basic Editor.

Press Ctrl+G to activate the Immediate window.

Paste the line (Ctrl+V)

Place the insertion point anywhere in the line and press Enter.