Use LLMs in Excel formulas
=PROMPT(A1, "Extract all person names mentioned in the text.")
in a cell’s formula and drag the cell to apply the prompt to many rows. Cellm’s =PROMPT()
function will output the AI response to a range of text, similar to how Excel’s =SUM() function will output the sum of a range of numbers.
=PROMPT()
function and returns short answers suitable for cells.=SUM()
function, you will quickly get the hang of Cellm’s =PROMPT()
function.