Breaking down a notes field

Hi
hi all,

I have an excel file that needs importing into the GoldMine application.
(GoldMine needs to have a dbf file for import) As you may know the longest a cell can be in DBF is 255 characters.
the notes in the excel sheet are large (in some cases a few thousand characters)

My idea is to insert a symbol or character at intervals in the text (every 200 characters or so) and then use the "text to columns" function in excel. So i'll end up with about 20 -30 columns of about 200 characters, which should then save ok as a dbf.

The only problem is I don't know how to insert a character (e.g. |) after every 200 characters. I'm sure it must be possible , can anyone help me out with that?

cheers
ICW

When you do text-to-column, you don't necessary have to find a symbol to split the column. You can use "Fixed width" to split the column. That way, you can split it however you want.