Can you give an example of the rules that need to be followed to allow this to work?

ie:

1. check all cells in column A for a special character - if found move to step 2.
2. all text in cell A, AFTER special character goes to bookmark 1 in the document.
3. text to the left of left of the special character goes to bookmark 2.
4. text in columns B, C & D go to bookmarks 3, 4 & 5

To make a formula that will take the right details you will need to give specific rules - looking at your image, I'm not sure what the rules are going to be!? Can you clarify? I think that it would make it a bit easier to help you that way!