Excel - count numeric digits at beginning of cell

[CD2017]

Hello,

I need to extract the digits from the beginning of a list of cells, regardless of number of digits.

Example here's the list, this will be in Column A, I need Column B to contain the numbers 1-15.

Any help would be appreciated!

Column_A[TABLE="width: 53"]
<tbody>[TR]
[TD]1:ABC[/TD]
[/TR]
[TR]
[TD]2:ABC[/TD]
[/TR]
[TR]
[TD]3:ABC[/TD]
[/TR]
[TR]
[TD]4:ABC[/TD]
[/TR]
[TR]
[TD]5:ABC[/TD]
[/TR]
[TR]
[TD]6:ABC[/TD]
[/TR]
[TR]
[TD]7:ABC[/TD]
[/TR]
[TR]
[TD]8:ABC[/TD]
[/TR]
[TR]
[TD]9:ABC[/TD]
[/TR]
[TR]
[TD]10:ABC[/TD]
[/TR]
[TR]
[TD]11:ABC[/TD]
[/TR]
[TR]
[TD]12:ABC[/TD]
[/TR]
[TR]
[TD]13:ABC[/TD]
[/TR]
[TR]
[TD]14:ABC[/TD]
[/TR]
[TR]
[TD]15:ABC

Column_B
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[Aladin Akyurek]

In b2 enter and copy down:

=IF(ISNUMBER(LEFT(A2,FIND(":",A2)-1)+0),LEFT(A2,FIND(":",A2)-1)+0,"")

 

[CD2017]

In b2 enter and copy down:

=IF(ISNUMBER(LEFT(A2,FIND(":",A2)-1)+0),LEFT(A2,FIND(":",A2)-1)+0,"")

Excellent - thanks!

 

[Aladin Akyurek]

Excellent - thanks!

You are welcome.