Re: stripping out a text string
From: hgrove (hgrove.1dex2r_at_excelforum-nospam.com)
Date: 09/30/04
- Next message: Julian Campbell: "Date - help"
- Previous message: hgrove: "Re: Series Trend"
- In reply to: benb: "stripping out a text string"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Sep 2004 15:06:00 -0500
benb wrote...
>I have a column of cells with text strings of varying lengths. The
last few
>characters of each string is an ID that I need to separate out from
the rest of the
>string. The ID follow the formate 3-characters, dash,
more-characters. Below are
>some examples of the text strings. . . .
..
>Examples:
>USD/CDS/MEX/BBVA-Madrid/E02-93622
>USD/CDS/COLOMBIA/E04-90881
>USD/CDS/MEXICO/E02-91435-A
>USD/CDS/MEXICO/M03-90870
An alternative approach. If these strings could contain arbitrary
characters, then the safest way to do this involves using a defiend
name like Seq referring to
=ROW(INDIRECT("1:1024"))
which returns an array of consecutive integers from 1 to 1024. Then use
it in formulas like
=RIGHT(A1,LEN(A1)-LOOKUP(2,1/(MID(A1,Seq,1)="/"),Seq))
or
=MID(A1,LOOKUP(2,1/(MID(A1,seq,1)="/"),seq)+1,1024)
-- hgrove ------------------------------------------------------------------------ hgrove's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11432 View this thread: http://www.excelforum.com/showthread.php?threadid=265206
- Next message: Julian Campbell: "Date - help"
- Previous message: hgrove: "Re: Series Trend"
- In reply to: benb: "stripping out a text string"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
