Adding |Pipe| to values in cells

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?

See Replace method …

Sorry need to add that the year make and model info all needs to be in one cell.

I have another issue with this. My data has a SKU column. That is the first column in the following example:
111 2007 Dodge Ram
111 2008 Dodge Ram
111 2010-2012 Dodge Ram
112 2007 Dodge Ram
112 2008 Dodge Ram
112 2010-2012 Dodge Ram

I would actually need the output to look like this:

111	2007|Dodge|Ram 2008|Dodge|Ram 2010-2012|Dodge|Ram
112	2007|Dodge|Ram 2008|Dodge|Ram 2010-2012|Dodge|Ram

I would need to put all of the data in the right format into one cell associated with the same SKU. Does this make sense?

Maybe:

Sub alholle2()
Dim rcell As Range
For Each rcell In Range("A2:A" & Range("A" & Rows.Count).End(3).Row)
    rcell.Offset(, 1).Value = Right(rcell, Len(rcell) - 4)
    rcell.Value = Left(rcell, 4)
    rcell.Offset(, 1).Replace " ", "|", xlPart
Next rcell
End Sub

Assumes Column A is your SKU Column