Trouble with a function

Hello sperl,

I sent the him a private message about your problem. Hopefully you will hear back from him today.

I still working on the Apple Script for this.

But since its a one time thing, you might try (if your poorly formatted data is in column A)
Put =SUBSTITUTE(A1,CHAR(13),",") in B1. (Your boss is mistaken, the linefeed (for Mac) is CHAR(13) not CHAR(10))
and drag down. Then Copy PasteSpecialValues to change it from formulas to values. Then you can use text to columns (comma delimited) to split out the columns.

Got It! The problem was to Get Value of bRange.

Open Script Editor and paste this into a new window.

tell application "Microsoft Excel"
	set ARange to range "A1" of sheet "Sheet1" of workbook "Workbook1.xls"
	set ARange to get resize current region of ARange column size 1
	set bRange to (get offset of ARange column offset 1)
	
	set formula of bRange to "=substitute(RC[-1],CHAR(13),CHAR(44))"
	
	set value of bRange to get value of bRange
	
	set display alerts to false
	text to columns bRange data type delimited with comma
	set display alerts to true
	
	delete range ARange shift shift to left
end tell

Run the script and the excel file should be converted.
BTW, if you need more help with Excel 2008/AppleScript, you could PM me.
If you need help with AppleScript, http://macscripter.net/index.php has been very helpful to me.