Alphanumeric

[T. Valko]

Possible improvement...

In your sample data all the number strings are the same length. So, if
that's the case then we can use much simpler formulas.

In B2:

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

In C2:

=RIGHT(A2,5) (returns a TEXT number)
=--RIGHT(A2,5) (returns a NUMERIC number)

The same condition applies to leading 0s.

 

[beejay]

thank you for the information
it works

Possible improvement...

In your sample data all the number strings are the same length. So, if
that's the case then we can use much simpler formulas.

In B2:

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

In C2:

=RIGHT(A2,5) (returns a TEXT number)
=--RIGHT(A2,5) (returns a NUMERIC number)

The same condition applies to leading 0s.

 

[T. Valko]

You're welcome. Thanks for the feedback!