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]

Have you tried a Find/Replace (Ctrl+H) using "* in the find box and leaving the replace box blank?

 

[SteveO59L]

Is the number always followed by the "> characters?

 

[grayg]

Is the number always followed by the "> characters?

Yes all are ">Quick Edit

 

[SteveO59L]

Try Rorya's suggestion, or

Text to columns, with the " as the delimiter, or

=LEFT(A1,FIND(">",A1)-2)

 

[anandvarma]

Try this

=left(a1,find("""",a1)-1)+0

 

[grayg]

Will need a little more help

I have put =LEFT(A1,FIND(">",A1)-2) in the destination field


But get Reference not valid error

Sorry not a expert at excel.......so will need a little more basic help....sorry

 

[SteveO59L]

You are using Excel, arent you?

 

[grayg]

Yes

go to Text to columns

Use "fixed width

click next and break lines ..........do nothing

click next and put your suggestion in the Destination field, leaving the "General" radio button checked

 

[anandvarma]

Try this

=left(substitute(a1,">","/"),find("/",substitute(a1,">","/"))-2)+0