In the pack: Gemini Prompts: 45 Free Prompts for Gmail, Sheets, Images, Live and Canvas
Sheets =AI Function: Pull One Field Out of Messy Text
Prompt
=AI("From the text in the given cell, extract the {{FIELD_TO_EXTRACT}}. Output it in exactly this format: {{OUTPUT_FORMAT}}, for example {{FORMAT_EXAMPLE}}. If the text contains more than one, output the first one only. If it contains none, output NONE. Do not guess, correct or complete a value that is not written in the text. Only output the value.", {{FIRST_CELL}})
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Sheets =AI Function: Pull One Field Out of Messy Text” is a free prompt for Gemini in the Business category, 128 words long, added to The Prompt Index on November 18, 2026 by The Prompt Index. Copy it with the button above, paste it into Gemini or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{FIELD_TO_EXTRACT}}, {{OUTPUT_FORMAT}}, {{FORMAT_EXAMPLE}}, {{FIRST_CELL}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 8 times.
Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.