Get week from text string

[welchs101]

Hi,

cant seem to get this right.........

I have the following text string

"Start Up: 15Wks"

Now the number 15 can vary...ie...the number 15 could be 153 or 4.......but i need to parse out the number just before the "Wks".

Any ideas?

[jeffreybrown]

With your text string in A1...

Courtesy of Ron Coderre
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000))))

[Ghozi Alkatiri]

try it array formula
{=MID(A1;MIN(IF(ISNUMBER(--MID(A1;ROW(1:1000);1));ROW(1:1000)));COUNT(IF(ISNUMBER(--MID(A1;ROW(1:1000);1));ROW(1:1000))))}

[welchs101]

thanks .........

[jeffreybrown]

You are very welcome...glad it worked out for you.

=====================================================

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.