In the good old days Lotus 123 had a great feature for parsing a string of text into individual cells. I think it was Data.Parse or something equally obvious.
Upon moving to Excel it took me a while but I eventually found the equivalent under something like slightly relevant yet obscure like Tools.TextToColumns Earlier versions of Excel at least had a 123->Excel key stroke converter which saved a lot of time at the start.
Now I have moved to Open Office and I can't find the thing again. I know it must be there. It used to be possible to force Excel to parse anyway by opening plain text files in Excel and getting it to bring up an import wizard which allowed you to specify where the column breaks were but Open Office is now so smart that it reckons you actually want to open the file in the word processor even though you start to open it in the spreadsheet. I have F1'd in Open Office (v2.0) but can't find anything of use.
Anyways, given a line like this :
31-JAN-05 CUSTOMER_A €15000
Does anyone know the commands to convert the 3 different fields into individual cells ?
Cheers,
z
Upon moving to Excel it took me a while but I eventually found the equivalent under something like slightly relevant yet obscure like Tools.TextToColumns Earlier versions of Excel at least had a 123->Excel key stroke converter which saved a lot of time at the start.
Now I have moved to Open Office and I can't find the thing again. I know it must be there. It used to be possible to force Excel to parse anyway by opening plain text files in Excel and getting it to bring up an import wizard which allowed you to specify where the column breaks were but Open Office is now so smart that it reckons you actually want to open the file in the word processor even though you start to open it in the spreadsheet. I have F1'd in Open Office (v2.0) but can't find anything of use.
Anyways, given a line like this :
31-JAN-05 CUSTOMER_A €15000
Does anyone know the commands to convert the 3 different fields into individual cells ?
Cheers,
z