MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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")