All I can offer is an alternative solution.
- Leave the cell with the original code.
- Make a lookuptable with the code as 'key' (first column) and full name, date and credits as the next three.
- Make three new columns.
- Put the right VLOOKUP-formula in the three new colums.
- Now you've got three separate fields, with you can use in a mail-merge.
Hope this helps.
Hello all =]
I have run into a problem that I thought would not be one...
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:
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.