Adjust Excel VBA to parse text input into additional formats

we have an excel parser that accepts text in A1, and parses to a specific format in same sheet. (see 1st tab in spreadsheet attached). The 2nd and 3rd tabs are additional formats we would like to have completed.

The 2nd tab uses same inout as 1st tab, and just formats it a bit differently.

The 3rd tab takes a differently formatted Input, and formats as shown.