Using the formula to fill a column with oracle text for card names found in adjacent cells in the next column over only fills that cell with the first line of text from the oracle value.
Example formula:
=IF(B370 = "", "", SCRYFALL(CONCATENATE("!",char(34),B370,CHAR(34)),"oracle"))
Where "B370" = Kudzu results in the cell only containing "Enchant land"
Using the formula to fill a column with oracle text for card names found in adjacent cells in the next column over only fills that cell with the first line of text from the oracle value.
Example formula:
=IF(B370 = "", "", SCRYFALL(CONCATENATE("!",char(34),B370,CHAR(34)),"oracle"))
Where "B370" = Kudzu results in the cell only containing "Enchant land"