Build an ID from a department and a number

Premium

Badge IDs are the first 3 letters of the department in capitals, a dash and the employee number, like MAR-1042. In C2, build the ID with LEFT, UPPER and &.

C2
ABCDEF
1Department Employee no. Badge ID
2Marketing 1042
3Finance 877
4Sales 1310
5
6
7
8

Premium lesson

Unlock Joining text with & and TEXTJOIN and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:SUBSTITUTE, TEXTBEFORE and TEXTAFTERDates and DATE

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?