Need all numbers before the ' , "

I have this numbers:

9612804582458251440721
9612804512755470468057
9612804512755470468088
9612804512755470468125,9612804512755470468132
9612804582458251441063
9612804512755470468217

I want to grab in a new column all number’s BEFORE the “,”

How can I do it?

Hi there! This formula should do it…

LEFT({Field Name}, FIND(",", {Field Name}) - 1)

Tanks for answering

But now it only shows up IF there is a “,”

The one with a “,” is blank

Please look on this Image

Try

LEFT(
    {Field Name},
    FIND(
        ',',
        {Field Name}&','
        )-1
    )

That concatenates {Field Name} with a trailing ',' so all fields will match the FIND() criteria.

Empty fields will cancel out with FIND(',',{Field Name}&',')-1 equal to 0.

1 Like

I am still only getting half

Why is this still empty?

Screenshot

Because I put the &',' in the wrong place. :blush:

Try the edited formula in my now-corrected reply, above.

Thank you very much, now its good