Extract Department Code from Employee ID
From Wikiprompt, the free prompt encyclopedia
Mar 24, 2026
Extract Department Code from Employee ID Extract text before a hyphen using LEFT and FIND.
Prompt ContentSave
🌐
Employee ID is in format HR-102 in column A. Write a formula to extract just the department code.
Sign in to see the full prompt
Continue with:
By logging in, you agree to our Terms of Use and Privacy Policy
Usage
This prompt is designed for use with productivity. Copy the prompt content above and paste it into your preferred AI tool.
For best results, you may customize the placeholders (indicated by square brackets or capital letters) with your specific requirements.
Talk
0 comments