Splitting 2 values in once cell to 2 other cells

[obionenairobi]

I have a database in which I have a cell in which 2 values are entered in one cell but seperated by a pipe '|' sign

to calculate with these values I need to extract those values into 2 new cells

example :

A1 : 1000,00 | 895,45

Should go to 2 new fields as shown below

B1 : 1000,00
C1 : 895,45

Can someone help me with this one ?

What happens if there is no entry before or after the pipe sign ?
Is it then possible to show a zero in one of the new cells (B1 or C1) ?

[JBeaucaire]

Use the Data > Text To Columns feature.

[zbor]

Select all (Ctrl+A or column A)
Replace (Ctrl+H) space with nothing
Close
Data -> Text to column -> Delimiter
Write | for delimiter
Finnish

[obionenairobi]

What I perhaps should have told is that the data is coming from a database via an ODBC query where the data is being using in a pivot table.
This is why I look for a formula rather than a manual correction

Is this not something that can be done via a formula ?

[martindwilson]

=LEFT(A1,FIND("|",A1)-1) and =MID(A1,FIND("|",A1)+1,255) you may need to put ; instead of ,