Well, all you need are the following functions.

InStr() to find the first occurance of the special character, and the first occurance of space following the first special character

SubStr() to snip out sections of the string

RPad() to pad out a string to a given length using a particular character