It is currently 28 Mar 2024, 23:41
StevieB wrote:Not sure on a Mac, but when we have odd format data at work I tend to copy it to a flat file (notepad or similar text editor) save that as a file and then 'import data' (DATA TAB -> FROM TEXT OPTION, then select the file you made) with excel, which lets you either specify a delimter or make fields a set width. That takes care of most situations.
Steve
Deejay wrote:Afternoon Andy
I've just tried it in Open Office on Win7.
The Username and Rank appear in the same column, but everything else looks OK.
You get options to save as various file types, one of which is CSV.
If you don't get the solution for a Mac, Open Office is free and there is a Mac version
PM me an address and I'll copy it and send it over if you want to try it.
Cheers
Dave
Return to The Woodmangler's Retreat
Users browsing this forum: Bing [Bot] and 15 guests