Yes:
"=MID(source,start,length)"

For the example given:
Source = D1,
start = 1, i.e., the first character in the string,
length =1, i.e., the number of characters to copy

Of course, if number of characters to be copied varies, as I suspect,
it gets more complicated, nor did you explain the significance of the
caret after the '5' character.


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=541882