Import a list of keywords into a set of fields that have a maximum of 50 characters
I would like to import a list of keywords into a set of four fields called search terms 1, search terms 2 etc. I can have a maximum of 50 characters in each field. So when the maximum is reached, or passed, I would like the import to the field to stop at the word which does not break the maximum allowance and continue the import into the next search term field. I don't know where to start. Can you advise me please?