How about: use the Text to Columns feature, using the as your
delimiter. This will split the strings into different columns; then
write a formula along the lines of =D1&C1&B1&A1 to reverse the word
order.