Left Formula which removes unnecessary characters and will display content if only one

I'm working on a formula that shows only the left numbers before a space. But I also need all commas and periods removed as well as show the value in the cell if there is only one number. So far I'm this far on the formula, but I'm getting #value if the originating cells has only one number in it, but I need that number to show if that is the only number...

=SUBSTITUTE(SUBSTITUTE(LEFT(A3,SEARCH(" ",A3,1)),",",""),".","")

How to add "show numbers in cell if no other numbers". Here is what it looks like now...

Original Numbers Need to show only left most numbers

Please Login or Register  to view this content.

Please help. Thanks.

~A

Moderator's note: Welcome to the Forum--I helped you out with formatting--6SJ

welcome to the forum, arodgers. maybe:
=INT(SUBSTITUTE(LEFT(A3,FIND(" ",A3&" ")-1),",",""))

I had success with this.

Formula:

Please Login or Register  to view this content.

It makes the following assumptions based on your example:

1. The first number in a list is immediately followed by a comma
2. If there is only a single number, there are no commas, spaces, or other characters in the cell

This seems to work with your example:

Formula:

Please Login or Register  to view this content.

try
=LOOKUP(9.99E+307,--MID(SUBSTITUTE(SUBSTITUTE(A1,".",""),","," "),MIN(FIND({1,2,3,4,5,6,7,8,9,0},SUBSTITUTE(SUBSTITUTE(A1,".",""),","," ")&1234567890)),ROW(INDIRECT("1:"&LEN(A1)))))