FinanceTier 315 minintermediate

Split a Combined Invoice Reference

Split a vendor code and invoice number that share one cell, separated by a dash of varying position.

What you will learn

• Locate a variable-position separator with FIND or SEARCH
• Split text either side of that separator rather than a fixed character position
• Explain why a fixed-position split breaks the moment the vendor code length changes

Excel skills

FIND, LEFT, MID, RIGHT · Text Cleanup

The task

Each reference combines a vendor code and an invoice number with a dash, but the vendor code isn't always the same length. In B2 and C2, split out the vendor code and invoice number using the position of the dash itself, not a fixed character count.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free