S, the only way I can think of will be cumbersome. If you select an entire page of your contributions, then paste it into an Excel file, you will have separate lines for each, but all the data will be in a single column. To split it into fields, I suspect the easiest way would be to first paste it into Word, where it won't even be divided into separate lines. There, you can do some search and replace actions to split some of the fields using the separators that Excel will recognize. After that, you can select your whole document and paste it into a blank Excel file.
The search and replace actions would be:
- Find: ]. Replace with: ^p (this is like deleting the"]." and typing the ENTER key at that spot to split the lines)
- Find: You Replace with: ^t (note that you want to type a space after You in the search field. This is like deleting " You " and typing a tab at that spot instead)
- Find: for Replace with ^t (include a space before and after the for in the search field. This is like deleting " for " and typing a tab at that spot)
- Find: [ Replace with ^t (include a space before the [ in the search field. This is like deleting the " [" and typing a tab at that spot)
- Now copy the entire Word document, open a new Excel document, and paste in the first cell in first row (A1). You should have columns for time, action, and profile name (which is a link to it). If you want date (which I would expect) on each line, you can select column A and insert a column, then each time you have a line that includes a date, you can copy that and paste it into your date column on all the lines from where the date is up to where you find the next date. Of course, you will also want to delete the original date entries.
I wouldn't do this for everyone, but you're special to me - you have helped me immensely in the past, so if you want, I'll do it for you if you let me know what contribution time period you want.
