I'm utilizing a CSV file to create some insert statements for SQL Server, and I'm using formulae to try and clean up my data before it gets inserted. I need to clean roughly 30 columns and 64,000 rows.
I've gotten most of the way through it, but a formula that checks that phone numbers are correct has recently started to fail and is no longer inserting the cleaned phone number into the cell, but rather just the formula's text. Other cells are using the same formula.
Is there a maximum amount of formulas that can be included in a workbook or worksheet?