Text function question.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top