K
Kristin =]
Hello all =]
I have run into a problem that I thought would not be one...
ok..
I have to generate transcripts for some conference attendees. I have a
spreadsheet with over 1,000 people on it, and every person could have
taken as little as 1 course to up to 11 courses (out of about 70
different courses).
At the conference, each attendee swiped their badge upon entry to the
room into a PDA. After attendance was done, the PDA's were retuned,
docked, and exported the attendee info into Excel by session. My plan
was to create merged document in Word using the Excel sheet as the
data source.
Now, I already had gotten over the issue of expanding the session
code, for example from:
CulturalEd
to:
Course: Cultural Education
Date: Monday, April 5, 2004
Credits Awarded: 2.5
in the cell (I just learned after many years about the Alt+Enter
magic). But NOW I have a new and more peculiar problem....
When I do a find for 'CulturalEd', that's no problem of course, but
when I copy the contents of the cell and click the option to 'keep
cell formatting', which would be to keep the line breaks in to look
like what's above, it converts it all into:
Course: Cultural Education Date: Monday, April 5, 2004 Credits
Awarded: 2.5
I SOOOO NEED to be able to do a find/replace that will keep the cell
formatting. Does ANYONE know how I could get around this? Like I
said, I have more than 4,000 courses that need to be expanded in this
manner so I can then import them into the Word document to print and
mail each person's indiviudalized transcript.
Thank -YOU- so much for taking the time to read all of this! I needed
to have this done like 2 weeks ago, and any assistance that will get
me closer to accomplishing this task is GREATLY appreciated.
-Kristin =]
I have run into a problem that I thought would not be one...
ok..
I have to generate transcripts for some conference attendees. I have a
spreadsheet with over 1,000 people on it, and every person could have
taken as little as 1 course to up to 11 courses (out of about 70
different courses).
At the conference, each attendee swiped their badge upon entry to the
room into a PDA. After attendance was done, the PDA's were retuned,
docked, and exported the attendee info into Excel by session. My plan
was to create merged document in Word using the Excel sheet as the
data source.
Now, I already had gotten over the issue of expanding the session
code, for example from:
CulturalEd
to:
Course: Cultural Education
Date: Monday, April 5, 2004
Credits Awarded: 2.5
in the cell (I just learned after many years about the Alt+Enter
magic). But NOW I have a new and more peculiar problem....
When I do a find for 'CulturalEd', that's no problem of course, but
when I copy the contents of the cell and click the option to 'keep
cell formatting', which would be to keep the line breaks in to look
like what's above, it converts it all into:
Course: Cultural Education Date: Monday, April 5, 2004 Credits
Awarded: 2.5
I SOOOO NEED to be able to do a find/replace that will keep the cell
formatting. Does ANYONE know how I could get around this? Like I
said, I have more than 4,000 courses that need to be expanded in this
manner so I can then import them into the Word document to print and
mail each person's indiviudalized transcript.
Thank -YOU- so much for taking the time to read all of this! I needed
to have this done like 2 weeks ago, and any assistance that will get
me closer to accomplishing this task is GREATLY appreciated.
-Kristin =]