I was trying to take off hyphen within a text string, such as "0100-00-000".

I used LEFT formula to return the first 4 digit. Then I used RIGHT formula

on the same cell to return the last 3 digit but somehow the formula doesn't

work. It won't give me a error message but just keep my formula in the cell.

Please help and thanks

## Bookmarks