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