hello guys ,

I have values in a column like this " 1234-5" or "12345-6"

and have the following questions

1.how do we change that to 12345/123456 or remove the dash in all values of that column
2.how do we change all values to this 1234 or 12345 (remove anything after -)

not sure which function I can use

any help is appreciated

thanks