separating specific number from long string of text

[ExxcelNoob]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="443"></colgroup> <tbody>
[TD="width: 443"][Live Dealer Baccarat - 1/12014651] Risk 5.0 | Win -5.0 --- [/TD]

</tbody>

[/TD]
[TD]Risk[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="443"></colgroup> <tbody>
[TD="width: 443"]

<colgroup><col width="443"></colgroup> <tbody>
[TD="width: 443"][Live Dealer Casino Hold'em - 1/12014763] Risk 30.0 | Win 10.0 --- [/TD]

</tbody>

[/TD]

</tbody>

[/TD]
[TD]Risk[/TD]
[TD]30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

<colgroup><col width="443"></colgroup> <tbody>
[TD="width: 443"][Live Dealer European Roulette - 1/12016731] Risk 11.0 | Win 9.0 --- [/TD]

</tbody>

[/TD]
[TD]Risk[/TD]
[TD]11[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]











Hello everyone, I'm trying to find a function on C1 to find the number of risk and put them in C1 through C3.

Can anyone help me separate the string of data by getting the number of risk by itself?

thank you

 

[JoeMo]

In C1 and copy down:

=MID(A1,SEARCH("Risk",A1)+5,SEARCH("|",A1)-(SEARCH("Risk",A1)+5))+0

 

[ExxcelNoob]

Hello Sir, can you take a look at my spreadsheet?

I tried it on my open office spread sheet, but it didn't work.

I also change the comma " , " from excel format to semicon " ; " but it didn't work also

 

[JoeMo]

Hello Sir, can you take a look at my spreadsheet?

I tried it on my open office spread sheet, but it didn't work.

I also change the comma " , " from excel format to semicon " ; " but it didn't work also

This is an Excel Questions Forum. I don't use Open Office so can't help you further.