Collecting information from a cell

[tcalas]

I would like to get the elements from col A but stop at 0.

For example, T02MC01X
I want to get all digits up to C like T02MC and not include what comes after C.
I have the following formula that only works for this case =LEFT(A3,5). If I have something like LDF01X the formula wouldn't work.

How can I create a formula that will do it automatically and collect info only up to the last digit before 0?

 

[Fluff]

Do you always want to exclude the last 3 characters?

 

[tcalas]

Do you always want to exclude the last 3 characters?

Yes, that is correct!

 

[Fluff]

In that case how about

=LEFT(A2,LEN(A2)-3)

 

[tcalas]

Tha

In that case how about

=LEFT(A2,LEN(A2)-3)

Thanks, that helped!

 

[Fluff]

You're welcome & thanks for the feedback.