Use of Excel Left, Right and mid function to extract text

In this lesson, we’re going to extract data from a string using Text Left Function, Text Right Function and Text Mid Function. Step#1: We’ll be using ISBN number from a table of books record to extract information into separate columns. Anatomy of ISBN Number is as follows. Digits 1-3 EAN (European Article Number) Digit 4 […]

Read More