Skip to content
TheChatArchiveThe Chat Archive
Qwenqwen3-235b-a22b-no-thinking· Alibaba (Qwen)Hugging Face LMArena Human Preference 140K

In Excel, looking for a way to pull the 10 characters after the first percentage…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with gpt-4.1-2025-04-14’s answer.
  1. User

    In Excel, looking for a way to pull the 10 characters after the first percentage character in a cell

  2. Qwen Assistant

    To pull 10 characters after the first % character in a cell in Excel, you can use a formula combining several text functions: FIND, MID, and optionally IFERROR.

    Assuming your text is in cell A1, here's the formula:

    =MID(A1, FIND("%", A1) + 1, 10)
    

    Explanation:

    • FIND("%", A1) finds the position of the first % character.
    • + 1 starts extracting after the %.
    • MID(..., ..., 10) pulls the next 10 characters starting from that point.

    Optional: Handle cases where % isn't found

    To avoid a #VALUE! error if % isn't present, wrap it in IFERROR:

    =IFERROR(MID(A1, FIND("%", A1) + 1, 10), "")
    

    This will return an empty string ("") if no % is found.

    Let me know if you want to extract all characters after %, not just 10.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.