Excel Problems

**Miz** · 06-30-16, 09:44 PM

a quick and dirty way might be to open it in word pad first, and replace all "-" with "#_". Then you might be able to open in excel, do text to columns using just # as your delimiter. Once they are in the correct columns replace "_" with "-"...

however the text to columns may not play nicely with games that have positive numbers.

I have had this issue before too. I can't recall exactly how I solved it... another option that may work is to turn your formula evaluation option to manual. However it may still evaluate it on file open.

**Waterstpub87** · 07-01-16, 08:29 AM

Originally posted by Miz

a quick and dirty way might be to open it in word pad first, and replace all "-" with "#_". Then you might be able to open in excel, do text to columns using just # as your delimiter. Once they are in the correct columns replace "_" with "-"...

however the text to columns may not play nicely with games that have positive numbers.

I have had this issue before too. I can't recall exactly how I solved it... another option that may work is to turn your formula evaluation option to manual. However it may still evaluate it on file open.

Thanks for the response Miz. Problem is fixed doing a manual copy paste. It is not an elegant solution, and its more time consuming, but for college football with 100+ games on a day, it isn't that bad. Excel has its limits.

**Miz** · 07-01-16, 01:01 PM

Glad you found something. I hear you on sometimes just using brute force

**a4u2fear** · 07-03-16, 05:45 PM

Waters, I've done numerous excel threads, look for them for help

**Waterstpub87** · 07-03-16, 11:43 PM

Originally posted by a4u2fear

Waters, I've done numerous excel threads, look for them for help

I have seen your threads in the past and they have been very helpful. I do not recall seeing a specific post regarding this. I am aware of how to get data into excel. It is the specific problem of excel autoevaluating expressions. If you have a solution, I would appreciate if you could point me in the right direction.

**statnerds** · 07-04-16, 06:39 AM

Originally posted by Waterstpub87

I am running automation via script so I don't want to and can't spot check. Has anyone had any luck fixing this or is there a work around that anyone knows?

if by script you mean VBA, then this should be simply a matter of changing .xlsx to .csv during download process

you could still have it automated converting it from csv to xlsx, although i don't see anywhere in this thread where you say you are running any formulas once you have the data.

**Waterstpub87** · 07-04-16, 11:22 AM

Originally posted by statnerds

if by script you mean VBA, then this should be simply a matter of changing .xlsx to .csv during download process

you could still have it automated converting it from csv to xlsx, although i don't see anywhere in this thread where you say you are running any formulas once you have the data.

This might be a solution. I am running game simulations after, so I would need formulas. Let me look into this. Thanks for the suggestion.