Find Value between characters in one cell

Hello,

I get this report-list of personal information, in text format (TXT)
Each area is separated by |

Name|Experience|Age|Sex|Location|Contact
Amy|6 years|28|Female|Address|Mobile
Fred|4 years|33|Male|Address|Home-Fone
Victor|8 years|37|Male|Address|Home-Mobile

...and so on.

Then I copy and paste it in to excel cell.
But ... after that i have to organize every area into their separate cell constantly.

Is there any formula, for each cell can find the word or value, between the characters |...|...|...|, and then automatically copies them to their respective cell.

Example;
[CELL] from the LEFT________________-________________{CELL} with pasted TEXT
[Name] [Experience] [Age] [Sex] [Location] [Contact] - {Name|Experience|Age|Sex|Location|Contact}

[Amy] [6 years] [28] [Female] [Address] [Mobile] - {Amy|6 years|28|Female|Address|Mobile}
[Fred] [4 years] [33] [Male] [Address] [Home-Fone] - {Fred|4 years|33|Male|Address|Home-Fone}
[Victor][8 years][37][Male][Address][Home-Mobile] - {Victor|8 years|37|Male|Address|Home-Mobile}


...Thanks