Your workbook structure doesn't exactly make it easy to extract the data. For example you don't have either a row or column titled 'college name', to match your entry in the Word file; all you have is 'College name' (note the difference in case) embedded in another string. It's also not apparent why you've set a loop to process rows 2 To 40 when your data only span 4 rows.

As for outputting .C
·C++
·Java
as bulleted text, you can't really achieve that by inserting bullets into Excel; you should instead insert the un-bulleted text (in Excel) into bulleted paragraphs in Word. To do that, of course, you'd need to have <<subjects>> in a bulleted paragraph in Word.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]