Re: Help with MID Function?
- From: "Rick Rothstein" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2009 19:35:53 -0500
Sure... just use the last formula I posted back in your first thread on this problem; namely,
=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),LEN(LOOKUP(9E+307,--LEFT(MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),999),ROW(1:999))))+1)
Change all the A1 references (4 of them) to whatever cell you have your text in. This formula can be copied down if necessary.
--
Rick (MVP - Excel)
"KLZA" <clawdogs@xxxxxxxxx> wrote in message news:3bab7101-e5d1-42f7-aac9-025ec443811d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi. I may not have explained myself well enough in my last post. So
here goes again.
I'm trying to capture / extract specific data within a string of text
in a cell. I need to capture a string of numeric characters plus only
the first alpha character immediately after the numbers. The numbers
of alpha characters varies before the numeric characters. So my cells
could look like this: TTTTT10TTTTTT or TTT1000TTTT or
TTTTTTT1TTTTTTTTTTTT etc.. My output from the cells would be 10T or
1000T or 1T etc... The text string before and after the number string
vary. Can this be done?
.
- Follow-Ups:
- Re: Help with MID Function?
- From: KLZA
- Re: Help with MID Function?
- References:
- Help with MID Function?
- From: KLZA
- Help with MID Function?
- Prev by Date: Re: Looking for "Select where in" type function
- Next by Date: Re: SUMIF and AND/OR/NOT
- Previous by thread: Help with MID Function?
- Next by thread: Re: Help with MID Function?
- Index(es):
Relevant Pages
|
