=LEFT Function

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tom (any_at_any.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 11:14:57 -0400

Using the function below will allow me to find the 1st character if
separated by a period.

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

For instance, it will provide me the following:
1.1 becomes 1
2.1.1 becomes 2

However, if I may have also a single digit that needs to become itself in
the function.
1.1 becomes 1
2.1.1 becomes 2 AND
3 becomes 3

How do I modify the "=LEFT(A1,FIND(".",A1)-1)" to pick up all the 3 previous
listed values (1, 2, 3)?

Thanks,
Tom

Quantcast