Text function question.

D

DP7

I have the following text string BR2248JZ91, I want to extract the 7th 8th &
9th values in the text string. In other words JZ9. I can’t figure out which
function to use to get that done. If anyone could shed any light on my issue
I would be VERY grateful
Thanks
 
T

T. Valko

Try this.

=MID(A1,7,3)

Where:

A1 = string
7 = 7th character, starting position of the first character you want to
extract.
3 = number of characters to extract
 
Top