gaftalik said:
... but if i have this in a formula :
=1+3+5
How to return 1 or 3 or 5
is it left(xxx(text or other ?...
Entered in B1 and copied across:
=WMID(SUBSTITUTE(FORMULATEXT($A1),"=","",1),COLUMN()-COLUMN($B$1)+1,1,"+")
where A1 houses =1+2+3.
The formula requires the morefunc add-in.
PS. Why do you need this manipulation?