Extracting numbers

[Korimint]

Hello,

I have a number that looks like this:

<TABLE style="WIDTH: 141pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=188><COLGROUP><COL style="WIDTH: 141pt; mso-width-source: userset; mso-width-alt: 6875" width=188><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 141pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=188>;6050110000002354271=2501</TD></TR></TBODY></TABLE>

and I would like to have it look like this:

6050110000002354271

I am not sure on what formula to write in order to achieve this, I have about 6000 rows to do.

I am using Excel 2007, Windows 7

Thanks for the help!

 

[njimack]

If they're all in that format, either of the below formulae would work

Excel Workbook
	A	B
1	;6050110000002354271=2501	60501100000023542712501
2	;6050110000002354271=2501	60501100000023542712501
Sheet1

EDIT - ignore this, just realised you didn't want the numbers after the equals sign

 

[CWatts]

You can use:

=MID(A1,2,FIND("=",A1,2)-2)

Dont convert it to a number because excel will truncate large numbers over 14 digits.

 

[Dryver14]

if number always same lengh then

=MID(A1,2,19)

 

[Korimint]

Thanks everyone!! Works great!!