Export Project 2010 notes data to Excel

Anonymous
2011-05-24T01:39:01+00:00

I am trying to export my notes field data from MS Project 2010 to Excel in order to populate other applications.

The problem I have is that the text of the notes has been pasted in from Word and contains carriage returns.

As a result when I export to Excel only the first line of the notes text - up to the first carriage return - will be exported and available in the Excel dump.

I can use a soft return (SHIFT ENTER) to replace the carriage return and can then get  all of the text but formatting is lost and it looks like a garbled mess - not withstanding the effort to manually replace all carriage returns with soft returns throughout ALL (ugh!) of the Project task notes.

Is there a solution to do this without the extreme manual effort and the substandard appearance that results?

If so, please tell, if not, then what do you recommend under the circumstances?

Many thanks in advance...

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
John Project 49,720 Reputation points Volunteer Moderator
2011-05-24T03:00:11+00:00

MickT_61,

Using an export map or simple copy and paste you will only be able to export Notes field text up to the first 255 characters or first line feed, whichever occurs first. I have a macro that will export the full notes text but unfortunately it will not preserve formatting. If you are interested, contact me at the address below. I will ask some questions.

John

jensenljatatfastmaildotdotfm

(remove obvious redundancies)

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
John Project 49,720 Reputation points Volunteer Moderator
2014-02-13T19:44:12+00:00

Eddy,

This is a rather popular thread. Your e-mail address was removed, (to protect you), but you can contact me at:

jensenljatatfastmaildotdotfm

(remove obvious redundancies and the 7th character is a letter

I will ask some questions.

John

Was this answer helpful?

0 comments
Answer accepted by question author
John Project 49,720 Reputation points Volunteer Moderator
2013-03-08T16:54:06+00:00

Users,

NunyaBiznas contacted me separately and I provided the macro.

John

Was this answer helpful?

0 comments

70 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. John Project 49,720 Reputation points Volunteer Moderator
    2016-09-30T18:04:25+00:00

    Patti,

    Where have you been? It's been over a week since you last posted.

    What I gave you is my e-mail address. It is encoded to prevent spam (i.e. extra "redundant" info is included and must be removed to create a valid e-mail address). Please try again. If you just can't figure it out, re-post with your e-mail encoded as below. That way it won't be removed for privacy as it has been in your last two posts.

    Patti at mail server dot com

    John

    P.S. It's not a good idea to list your real phone number on a public forum. I suggest you edit your post and remove it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-11-08T15:57:55+00:00

    Was this answer helpful?

    0 comments