If allowed to use VBA, here's a function I just made:

Function CellText(rng As Range)
    CellText = rng.Text
End Function

It has no issue with custom formats, but macros need to be allowed to run.