It's Ascii 124 - a pipe sometimes called 'logical or' symbol

It's on the Keyboard, usually on the \ (backslash) key

Code:
mystr = "VALUE||||||"
mystr=Replace(mystr,chr124),"")