The default field separator is a Tab. Use the -t argument to change the field separator.

BCP "SELECT * FROM Table1..Users" queryout "C:\file1.txt" -T -N -t"|"