Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2016, 03:57 PM
anewteacher anewteacher is offline Word Macro to format transcript data Windows 7 64bit Word Macro to format transcript data Office 2010 64bit
Novice
Word Macro to format transcript data
 
Join Date: May 2014
Posts: 2
anewteacher is on a distinguished road
Default Word Macro to format transcript data

Hello,



I am a teacher trying to help students determine their course fulfillments for graduation.

The official school website is not very friendly and does not give students an easy to look at format for classes taken and their GPA.

When copy and pasted into word (copy as text) it shows the following:

Summer III 2012 1 COMM 1304 A << Fall 2014 1 ENGL 3304 B
Summer III 2012 1 BUS 3300 C << Fall 2014 1 ENGL 4304 A
Fall 2012 1 BUS 3300 B << Fall 2014 1 ENGL 3302 A <<

I would like to have students view it as this:

Year(tab)Semester(tab)Course(tab)Grade(A)
2012(tab)Summer III(tab)COMM 1304(tab)A
2014(tab)Fall(tab)ENGL 3304(tab)B
2012(tab)Summer III(tab)BUS 3300(tab)C
2014(tab)Fall(tab)ENGL 4304(tab)A
2012(tab)Fall(tab)BUS 3300(tab)B

sample file.docx<<please look at sample file for current formatting

This way we could export the text into excel (because of the tab delimited format). Then we could create a table from the data and sort accordingly.

Is this possible? Any help would be greatly appreciated! =)
Reply With Quote
  #2  
Old 01-25-2016, 05:11 PM
macropod's Avatar
macropod macropod is offline Word Macro to format transcript data Windows 7 64bit Word Macro to format transcript data Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your data might be easier to work with if you simply pasted it into Word or Excel. Tabular data from web sites often pastes into either app in a table format. It would be a lot simpler to clean up such data that to try to reformat the text.

As for sorting, Word can sort table data, too.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to pull data out of a Word table shanemarkley Word VBA 20 05-07-2015 01:36 PM
Word Macro to format transcript data Macro to format unpredictable data Nisio07 Excel 2 09-30-2014 01:16 PM
Word Macro to format transcript data How to format WORD data using edit field? Azuki Mail Merge 2 04-01-2013 06:08 PM
Word Macro to format transcript data Paste data in "Accounting"format from Excel into Word changes formatting cory_0101 Word 4 10-17-2012 12:30 PM
Word Macro to format transcript data Word Macro to get pdf data appended janith Word VBA 1 04-18-2012 12:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft