CODEWITHSUNDEEP
excelcsvexcel-formulaexport-to-csv
Whitecat
Whitecat

Reputation: 4020

Stop excel from converting formula to text csv

How do I keep excel from removing my formula inserted into a csv to text?

For example in my csv I have data and have the formula "=ISNUMBER(SEARCH($A$1,B2))" then I open the csv in excel and see the value of the formula. But when I save, the formula is removed and replaces it with the evaluation of the formula, i.e. true.

Upvotes: 1

Views: 303

Answers (1)

Amit Kohli
Amit Kohli

Reputation: 2950

I assume that you have a column of formulas that need to have an "=" added to it... so put your cursor on that column, and then run this macro:

Sub equalAdder()
While ActiveCell.Value <> ""
    ActiveCell.Value = "=" & ActiveCell.Value
    ActiveCell.Offset(1, 0).Activate
Wend
End Sub

How does that work?

Upvotes: 1

Related Questions