I'm trying to take data out a .pdf and organize it in excel. I can
select the text but when i put it into excel i end up with everything
in one big column. Each entry has the name of a business in capital
letters and then some information about the buisness in the following
rows (in lower case letters) and then the name of anoth business in
capital letters. Unfortunatly the number of rows below each business
varies... So, I was thinking i could create some sort of a Macro that
looks for capital letters and then slects all of the text down until it
reaches another set of capital letters, slects the text, and then puts
it into a column. Any suggestions on how to get excel to do that? any
help would be greatly appreciated.