Extract a number from the data string in Cell

[abdulkharij]

Hi Dears,

I would like to ask if it's possible to extract a number 500005 to Cell C2 from the following data string in Cell A2 :

[TABLE="width: 423"]
<tbody>[TR]
[TD="class: xl63, width: 423"]Cost Center: 4545544 Provo

Earning: Miscellaneous (MISC)

Employee: XXXXXXX

Fund: 113 Sponsored Programs

Job Profile: Assistant - BIOL.

Line of Business: LOB002 Traditional

Location: Main Campus

Pay Group: Semi-Monthly Exempt

Position: Assistant, Biology

Program: 200 Sponsored Programs

Run Category: Regular

Simmons Grant: 454545 Davis Educ Fdtn-PLAN Prof Dev

Spend Category: Salaries - Faculty Extra Comp (500005)[/TD]
[/TR]
</tbody>[/TABLE]


Thank you,
ABDEL

 

[Haluk]

Another alternative, using Mr. Rothstein's formula given in his message #2 :

=TRIM(RIGHT(SUBSTITUTE(A1,":",REPT(" ",99)),99))