Can you give an example of the rules that need to be followed to allow this to work?
ie:
- check all cells in column A for a special character - if found move to step 2.
- all text in cell A, AFTER special character goes to bookmark 1 in the document.
- text to the left of left of the special character goes to bookmark 2.
- 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!