I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a way to make formula information in a cell more permanent?
For example; a field that I am using a formula for (
=A4) is being imported (when in csv) as Excel Metadata rather than the contents of
A4. How do I make the contents more "permanent" with excel?