Drop a prefix with RIGHT and LEN

Premium

Every order ID starts with a 3-letter channel code, but the numbers have different lengths. In B2, take everything after the first 3 characters with RIGHT, and use LEN(A2)-3 for how many.

B2
ABCDEF
1Order ID Number
2WEB10482
3APP981
4WEB2210377
5
6
7
8

Premium lesson

Unlock LEFT, RIGHT and MID 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:FIND and SEARCHJoining text with & and TEXTJOIN

It comes up in this mock test: Excel test for admin jobs

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?