Try this.

=MID(A1,7,3)

Whe

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

--
Biff
Microsoft Excel MVP


"DP7" wrote in message
...
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