separating wta tennis stat

[ExxcelNoob]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="class: parts, width: 550"]
<tbody>[TR="class: odd"]
[TD="class: summary-vertical fl"]0


[/TD]
[TD="class: score stats, align: center"]Aces[/TD]
[TD="class: summary-vertical fr, align: right"]

1
[/TD]
[/TR]
[TR="class: even, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F0F0F0]#F0F0F0[/URL] "]
[TD="class: summary-vertical fl"]5


[/TD]
[TD="class: score stats, align: center"]Double Faults[/TD]
[TD="class: summary-vertical fr, align: right"]

1
[/TD]
[/TR]
[TR="class: odd"]
[TD="class: summary-vertical fl"]68%


[/TD]
[TD="class: score stats, align: center"]1st Serve Percentage[/TD]
[TD="class: summary-vertical fr, align: right"]

70%
[/TD]
[/TR]
[TR="class: even, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F0F0F0]#F0F0F0[/URL] "]
[TD="class: summary-vertical fl"]47% (22/47)


[/TD]
[TD="class: score stats, align: center"]1st Serve Points Won[/TD]
[TD="class: summary-vertical fr, align: right"]

50% (19/38)
[/TD]
[/TR]
[TR="class: odd"]
[TD="class: summary-vertical fl"]41% (9/22)


[/TD]
[TD="class: score stats, align: center"]2nd Serve Points Won[/TD]
[TD="class: summary-vertical fr, align: right"]

63% (10/16)
[/TD]
[/TR]
[TR="class: even, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F0F0F0]#F0F0F0[/URL] "]
[TD="class: summary-vertical fl"]30% (3/10)


[/TD]
[TD="class: score stats, align: center"]Break Points Saved[/TD]
[TD="class: summary-vertical fr, align: right"]

0% (0/4)
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]









Hello everyone, in excel spreadsheet I wanted to separate all the information above into number format. I couldn't pasted as number, the information I pasted just appear to be in text format. What formula can I use to separating the information above into each category. Such as in "1st serve point won", I wanted each number to be in each cell, such as this

[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]1st serve percentage[/TD]
[TD]68%
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1st serve points won[/TD]
[TD]47%[/TD]
[TD]22[/TD]
[TD]47[/TD]
[/TR]
</tbody>[/TABLE]

 

[JimboP77]

How about using text to columns method?

 

[ExxcelNoob]

I had, but it only in text format and when I pasted the information the information always have ( ' ) in front of it. I needed number format.