In the column adjacent to the data (let us say data are in column A:A),
use the following formula in the first cell (B1 in here)
="|"&A1

HTH
Kostis Vezerides