| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the text between last comma and last but one comma.
*Maybe* this:
=LEFT(MID(A1,SEARCH("seq=",A1),255),FIND(",",MID(A 1,SEARCH("seq=",A1),255))-1) Returns: Seq=343 -- Biff Microsoft Excel MVP "Sreedevi" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract the text between last comma and last but one comma.
If you only want to keep the Seq=###, you could do this, too:
Select the range to fix Edit|Replace what: *Seq (asterisk, Seq) with: Seq Replace all Then Edit|Replace what: ,* (comma, asterisk) with: (leave blank) replace all The asterisk is a wildcard that represents any set of characters. Sreedevi wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| How can I extract the first & last name separated by a comma | Excel Discussion (Misc queries) | |||
| To only get all text after a comma | Excel Worksheet Functions | |||
| Extract comma broken address to cells | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Hybrid Mode
