Can you seperate text from one cell into other cells?

Is it possible to that the contents of a single cell and and place text of that cell into separate cells?
From a web output I have some like the following in my first cell

asdfsdf|adkjoi|fdf234sd|fsf3ie43|||asdfjlkei393|dfjvie|d||adfjei|...goes on with 28 "|"

The text is in A1 and I would like it to take the first string of characters up to the | and place it into cell A2
Then take the next set of characters up to the next | and place into cell A3 and so on.
Once the cell in A1 has been completely separated, go down to the next row and do the same until it reaches the end of the data.
Normally I would create a text file with the web data and then import that in with "|" delimited fields but I don't want to create that extra step for the user.

Can you use Text-To-Columns with "|" as the delimiter?

Nope, looks like it just dropped through with nothing. Below is a full line from my file.
S5000378-1_MX_1301020|3PAR|3PAS3|NS1050F1013|AK01|AK17|5200399304|00130|12/12/12|02/01/13|S5000378-1|||A|PAT||||1||||||||F|TM|CLEAR|

Originally Posted by JOHN H. DAVIS

Can you use Text-To-Columns with "|" as the delimiter?

Ummm yep that worked great, but now I feel like a dunce. Thank you John

You're welcome. Glad to help out.