I only want numbers in the cell

[Cushlapper]

This is frustrating b/c I'm not Mr. Excel, but I have a TON of numbers to go through and they all have dates and times in the same cell... how so I just get the numbers by themselves (easily) so I can do simple addition?

Thanks, Cushlapper

 

[T. Valko]

This is frustrating b/c I'm not Mr. Excel, but I have a TON of numbers to go through and they all have dates and times in the same cell... how so I just get the numbers by themselves (easily) so I can do simple addition?

Thanks, Cushlapper

How about showing us SEVERAL representative examples of the data and tell us what result you expect.

 

[Cushlapper]

right, here tis:

<TABLE style="WIDTH: 156pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=208><COLGROUP><COL style="WIDTH: 156pt; mso-width-source: userset; mso-width-alt: 7395" width=208><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 156pt; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 width=208></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>1988, 1, 10, 12:00, 89242</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>1988, 1, 11, 12:00, 106249</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>1988, 1, 12, 12:00, 110530</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>1988, 1, 13, 12:00, 115233

Beginning at A2 and down to A8760... I'm looking for the last numbers only.
</TD></TR></TBODY></TABLE>

 

[Michael M]

Could use Text to Columns, with the comma as the delimiter ?

 

[Trebor76]

Are the first set of numbers (time) always in the format you've shown so...

1988, 1, 10, 12:00

...would be the same format for 10:00 am on the 2nd of January 1988?

Robert

 

[Cushlapper]

duh... I forgot that from 5 years ago. Thanks for the reminder Michael! appreciate the help.