If these are in column A, then copy this to column B to retain the
original data. Then highlight column B and do Data | Text-to-columns
and specify | as the delimiter.

Hope this helps.

Pete