excel trailing less than $10 part removed

Hello, I'm glad to answer this question for you,

If you need to remove the last 4 digits, replace 123 words

You can type the function in cell B1 as shown in the chart formula = REPLACE (A: A, LEN (A: A) -3, 4, 123)

If the number of digits removed from the tail for the N, the function in the formula LEN(A:A)-3 part, modified to LEN(A:A)-N+1 can be.

If you need to replace other characters, you can change the 123 at the end of the function to the character you need to replace.

If you need to remove the last 4 digits, replace the 123 words

You can type in cell B1 as shown in the function formula = REPLACE (A: A, LEN (A: A) -3, 4, 123)

If you remove the end of the number of digits of the words, the function of the formula in the LEN (A: A) -3 part, modified to LEN (A:A)-N+1 can be.

If you need to replace the other characters, you can function at the end of the 123 modified into the characters you need to replace.