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.
npx skills add ECNU-ICALK/AutoSkill --skill excel-formula-for-right-to-left-text-extraction --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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
- Prompt
- Triggers
What does the Excel Formula for Right-to-Left Text Extraction skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill excel-formula-for-right-to-left-text-extraction --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.