Unit A 1 is strong steel wire bearing skipping rope -0042.

If you want to display the results in B 1, you can enter a formula in B 1.

=MID(A 1，FIND("-"，A 1)，9999)

By the way, 9999 in the formula refers to extracting 9999 characters on the right from the minus sign. If there are not so many characters, there are as many characters as there are. You can change this 9999 at will, as long as you ensure that the number you fill in must be greater than or equal to the number of characters you want to extract. It is recommended to fill in a larger one, so don't worry about filling in a smaller one.

In addition, English and numbers are regarded as 1 characters, and Chinese characters are regarded as 2 characters.