Hi, I have a couple of hundred of pages of data in a similar format, and wanted to see if there was some way in which I could input it into excel into columns as needed without having to make changes manually. The data is formatted as follows:

...
TA454516 UNIBANCO-UNIAO DE BANCOS BRAS. S.A. SP
UNIBANCO - UNIAO DE CAYMAN, ILHAS USD 140.663,25
TA454753 BANCO VOTORANTIM S.A. SP
ZURCHER KANTONALBAN SUICA CHF 1.710.000,00
TA454983 BANCO SANTANDER S.A. SP
TORONTO DOMINION IN CANADA USD 269.109,82
...

Where each two lines correspond to one row entry; the first element is a serial number (TA454516 ), followed by a name (UNIBANCO-UNIAO DE BANCOS BRAS. S.A.), then a desingation of two characters in the end of the first line (SP). the second line has a name (UNIBANCO - UNIAO DE CAYMAN, ILHAS ), followed by a currency designation (USD), and then a number (140.663,25). Can I somehow do it with a macro? With the data as is, there is one space between every word. Thanks so much for your help.

Thanks and regards,
fergzzq