Thread: extract text from string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AskExcel AskExcel is offline
external usenet poster
  
Posts: 19
Default extract text from string
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
Reply With QuoteReply With Quote