Try one of these:

=LEFT(RIGHT(A1,8),4)

=MID(A1,FIND(",",A1)+3,4)

--
Biff
Microsoft Excel MVP


"AskExcel" wrote in message
...
hi,
i have string as below. i need to extract 4 letter after the ','. the 4
letter is ABCD,AEGR,RTYT and TYRE.
may i know how to extract?
thanks

d123,00ABCD9657
d1005,12AEGR8678
d23,23RTYT6545
w345676,23TYRE7786