AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
Is there a way to structure Multiple SUBSTITUTE Functions? I have two values in a text body within a cell that I want to change, this works...
=SUBSTITUTE(B26,"Amount",$H$8)
...however I want to include "Name" (Which is linked to H7) as well.
Andy
=SUBSTITUTE(B26,"Amount",$H$8)
...however I want to include "Name" (Which is linked to H7) as well.
Andy