Reading Text into Excel

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

Do you want the two lines to be in one row after you're done or still in two rows?

Assumptions:
No header row
Data is in column A
You don't want column A or gaps in rows after the splitting of the data.


Remove the ' in front of the blue '*1 if you want the data in the column to be usable as numeric value - I'm guessing this is "European" formatting of numbers.

Please Login or Register  to view this content.

Perfect! Thank you so much I really appreciate the help!