Auto-formatting Dates And Running Spaces And Preceding Data Issues: Importing Data from PDF Files Excel help response (26 Jul 2013)

Hi, this is an excellent tool. Thank you for developing it. I am having a problem with the auto-formatting features for dates in excel. My data in excel looks like this: (Name of 1st School) (full URL of school website) Address: (School Address) County: (County) Phone: (Phone #) Grade Range: (Grade Range) Enrollment: (Enrollment #) District: (District) Fax:(Fax) Personnel: (Person's name Person's position) (There also may be additional people listed below or just one person listed) (Name of 2nd School) ...etc When I extract the "Grade Range", Excel is formatting what should be "1-8" or "9-12" as January 8th or September 12th. When I try to reformat after conversion back to text, the number is like 45193. Do you have a solution to keep it as "1-8", "7-12", "9-12", etc? Also, I obviously have problems with there being spaces between everything, including extra spaces within the "Personnel" line. And there is nothing unique preceding the "Name of n-th School" field. They aren't even numbered. It basically just says "Happy Mountain Example School". I would really like to extract that "Name of n-th School" field, if possible. It also creates problems with the "Personnel" field. Because if I want to get all of the "Personnel" (because there may be more than one), I have to put the end text as "Address:" because it is the only next unique text. I could use "full URL of school website", but not every school has one and nothing precedes that field. Will it help that the "Name of the n-th School" field is always in bold? A solution to either of these issues would be much appreciated. Again, thank you for this great utility.

Auto-formatting dates and running spaces and preceding data issues

Excel Help for Auto-formatting Dates And Running Spaces And Preceding Data Issues in Developing Business Administration Solutions

Auto-formatting Dates And Running Spaces And Preceding Data Issues

	Hi, this is an excellent tool. Thank you for developing it. I am having a problem with the auto-formatting features for dates in excel. My data in excel looks like this: (Name of 1st School) (full URL of school website) Address: (School Address) County: (County) Phone: (Phone #) Grade Range: (Grade Range) Enrollment: (Enrollment #) District: (District) Fax:(Fax) Personnel: (Person's name Person's position) (There also may be additional people listed below or just one person listed) (Name of 2nd School) ...etc When I extract the "Grade Range", Excel is formatting what should be "1-8" or "9-12" as January 8th or September 12th. When I try to reformat after conversion back to text, the number is like 45193. Do you have a solution to keep it as "1-8", "7-12", "9-12", etc? Also, I obviously have problems with there being spaces between everything, including extra spaces within the "Personnel" line. And there is nothing unique preceding the "Name of n-th School" field. They aren't even numbered. It basically just says "Happy Mountain Example School". I would really like to extract that "Name of n-th School" field, if possible. It also creates problems with the "Personnel" field. Because if I want to get all of the "Personnel" (because there may be more than one), I have to put the end text as "Address:" because it is the only next unique text. I could use "full URL of school website", but not every school has one and nothing precedes that field. Will it help that the "Name of the n-th School" field is always in bold? A solution to either of these issues would be much appreciated. Again, thank you for this great utility.
	Posted by xcfreek58 on 26 Jul 2013