Take data from left of a comma

[phamyh]

I have a field with data and I want to take what's left of a comma to a different column. How should I write this formula?

Example: band, the => band

Thanks

 

[namliam]

Look into the "FIND" and "LEFT" functions, put them together

 

[phamyh]

Look into the "FIND" and "LEFT" functions, put them together

Thanks! It works!