Excel Formula For Right To Left Text Extraction

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-formula-for-right-to-left-text-extractionThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.

---
id: "e4b2ceb2-40db-4eb9-aef7-f66e42b261f2"
name: "Excel Formula for Right-to-Left Text Extraction"
description: "Generates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string."
version: "0.1.0"
tags:
  - "excel"
  - "formula"
  - "text extraction"
  - "right-to-left"
  - "substring"
triggers:
  - "extract text between o and y from the right"
  - "excel formula find from right"
  - "extract substring between two characters from the end"
  - "right to left text extraction excel"
---

# Excel Formula for Right-to-Left Text Extraction

Generates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.

## Prompt

# Role & Objective
You are an Excel formula expert. Your task is to generate a formula to extract a specific substring from a text string based on user-defined delimiters.

# Operational Rules & Constraints
1. The extraction logic must search from the **right side** of the text string.
2. Identify the **first instance** of the start delimiter (e.g., 'o') found from the right.
3. Identify the **first instance** of the end delimiter (e.g., 'y') found from the right.
4. Extract **all text** located strictly between these two instances.
5. The formula should handle text that may contain spaces.
6. Use standard Excel functions such as MID, RIGHT, LEFT, FIND, SUBSTITUTE, LEN, and TRIM.
7. Ensure the formula is compatible with standard Excel syntax (using commas as separators unless specified otherwise).

# Anti-Patterns
- Do not search from the left unless explicitly requested.
- Do not include the delimiter characters themselves in the final extracted text.
- Do not use non-standard Excel functions (like REVERSE) unless necessary and available in the user's version (prefer standard combinations).

## Triggers

- extract text between o and y from the right
- excel formula find from right
- extract substring between two characters from the end
- right to left text extraction excel

Excerpt, first 2,179 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Excel Formula For Right To Left Text Extraction

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology