Try this small UDF:

Function formulaa(r As Range) As String
formulaa = ""
If r.HasFormula Then
formulaa = Replace(Replace(r.Formula, "=", ""), "+", "")
End If
End Function

Note that the "=" and the "+" are both discarded
--
Gary''s Student - gsnu200817


"Gilbert DE CEULAER" wrote:

Cell M20 contains "Whatever".
Cell S90 contains "+M20"
In order to verify things, in T90, I want to know the row, column, or
address of what is really in S90, I mean I want "M20", not the contents
("Whatever").
How can I do that ?
(Actually, in T90? I want to make a formula checking whether the
column-number mentioned in S90 ("M"=13) is less, equal or greater than the
column-number of S90 itself ("S"=19)).