I have a similar situation.

I have a single cell that looks something like this:
2007 Dodge Ram
2008 Dodge Ram
2010-2012 Dodge Ram

I would need to keep all of that data in one cell and make it look like this:
2007|Dodge|Ram
2008|Dodge|Ram
2010-2012|Dodge|Ram

Is this possible?