Split column DIGIT to NON-DIGIT

[Oros]

Hello.  

I tried to split a column from DIGIT to NON-DIGIT, but the decimal is created in another column.  Any help is appreciated.  Thanks.

This SHOULD BE the result:

But this is the result (wrong)

[Nathaniel_C]

Hi @Oros ,

Any other parameters or restraints? Will these all be grams? or will they all be 4 letters at the end?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Oros]

Hi @Nathaniel_C ,

I also have KILO but basically 4 letters.  Thanks.

[Nathaniel_C · Accepted solution]

Hi @Oros 

You are on the right track, but split by number of characters.  Go to home tab, split column,number of characters.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[Oros]

Thanks @Nathaniel_C 

[Nathaniel_C]

Hi @Oros ,

You are very welcome!

Nathaniel