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

355.5, 355.8, 355.3, 355.5	3555 
355.8				#VALUE!
355, 355.8, 355.3, 355.5	355 
735				#VALUE!
735, 735.4, 736.72, 838.01	735 
728.71				#VALUE!
355.8, 355, 355.3, 355.5	3558 
735.2				#VALUE!
355.8				#VALUE!
232.8				#VALUE!
355.8, 956.2, 976.1, 338.49	3558

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:

=IFERROR(SUBSTITUTE(LEFT(A1,FIND(",",A1)-1),".",""),SUBSTITUTE(A1,".",""))

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:

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

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)))))