Thread: Extract the text between last comma and last but one comma.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sreedevi Sreedevi is offline
external usenet poster
  
Posts: 1
Default Extract the text between last comma and last but one comma.
I have a very long text in a cell. EX:
4919,"0.019999","7.2.84.192","10.160.18.52","RTP", "PT=Unknown (99), SSRC=0x0,
Seq=343, Time=514216 "

I need to extract only the Seq=343 portion of it. The length of the text is
not constant in all the rows. Also, the sequence number is sometimes 2/3/4/5
digit.

Please help
Reply With QuoteReply With Quote