Extract Text From Spreasheets
Extract Text From Spreasheets
Hello Programmers,
Would some one please assist me. I have a excell spreadsheet, which I have
to
manually extract text from cells.
How do I take text from say the first 10 lines of the spreadsheet, copy
that text,
disregarding the cells, and placing the extracted text into a text
document. However,
here is the rub. The contents of each cell must have a return after each
entry.
For Example
From this:
Mr Paul Johnson 2435 Rosewood drive, Rosewood California, 22345, Rose@
goto.com. 1-800-258-3490. Comments: he has moved.
To This:
Mr Paul Johnson
2435 Rosewood Drive,
Rosewood California, 22345,
Rose@ goto.com. 1-800-258-3490.
Comments: he has moved.
I am running Macintosh, OS10 Panther, with AppleScript Editor.
Thanks Much!
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.