What if I have Prime Numbers in the column..how can I keep them as is with
this formula?

"Gary''s Student" wrote:

=LEFT(A1,FIND(".",A1)-1)
--
Gary''s Student - gsnu201001


"Data Analyst" wrote:

Here is the issue: I have numbers like this one - 10000.01.01.200

I just want the prime number 10000. How can I do that? I tried Ctrl+F and
replace but is there a more efficient way?

Thanks!