How do I get just the numeric number

[grayg]

I have a data base dump that has given me a string, but I only require the number:-

<TABLE style="WIDTH: 386pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=514 border=0><COLGROUP><COL style="WIDTH: 386pt; mso-width-source: userset; mso-width-alt: 18797" width=514><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 386pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=514 height=20><a href="/nmsapp/woMainQuickEditForm.html?woId=129395">Quick Edit...</a></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20><a href="/nmsapp/woMainQuickEditForm.html?woId=129324">Quick Edit...</a></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20><a href="/nmsapp/woMainQuickEditForm.html?woId=129194">Quick Edit...</a></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20><a href="/nmsapp/woMainQuickEditForm.html?woId=129175">Quick Edit...</a></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20><a href="/nmsapp/woMainQuickEditForm.html?woId=129162">Quick Edit...</a>

This is 5 entry lines to show each line has the same data (except the number)

</TD></TR></TBODY></TABLE>
Is there and easy way to strip out only this data as I have 5000+ enteries

Regards

Gary

 

[RoryA]

That was a formula to go in a cell, not the destination for the Text To Columns wizard. For that, just enter a cell reference like A1.

 

[SteveO59L]

Text to Columns, Delimited.

Use the Other box to specify the " character

 

[grayg]

Ok stupid question

do I highlight column A from the first field I want to change down to the last

then put the formula in????


As I said not an expert at excel and need Basic help