very quick substitute ?
Posted by Allan on February 28, 2001 6:13 AM
In cell A1
I have the text "A"
When I place this in A1
=SUBSTITUTE("A1","A","AA")
Why won't it work
thanks...in advance
Posted by Aladin Akyurek on February 28, 2001 6:47 AM
Try:
=SUBSTITUTE(A1,"A","AA")
