I'm afraid that the calc engine does not support text level formatting in versions of FileMaker prior to v7, so any calc procedure at all will strip text formatting.

If you are using v6. I suggest that you try scripting a procedure which uses the Find/Replace command instead, and see how you go with that.

Find/Replace doesn't strip the formatting, but I couldn't get it to replace the line breaks (I'm finding "

Hi,

The '

Awesome!!! Thanks, the line breaks are now gone. Any ideas on how I can stick stuff to the front and end of fields without loosing formatting?

Thanks

tell application "FileMaker Pro"

tell document 1

tell current record

copy cellValue of cell "Text data" as styled text

end tell

end tell

end tell

tell application "Microsoft Word"

--make new document

activate

paste

end tell

..

now do some search and replace with the text format search on ....

... you may also try:

tell application "FileMaker Pro 7"

tell document 1

tell current record

go to cell "Text data"

paste

end tell

end tell

end tell

tell?

Is that some script? If so, I'm totally unfamiliar with it. Would you give some more info please?

TIA

It's AppleScript.