title: Excel nested Substitute function macro ? (more than 64 nest)
body: <p>Hi I want to create a macro in Excel to replace characters of each word in a sheet to some different characters in new other sheet in the same cell. I have used substitude funtion but it allows me to use it for 64levels only. I have about 100 or more nests. Please guide....</p>
  
  <p>For Example:</p>
  
  <pre><code>=
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  SUBSTITUTE(
  G1,
  "a","T"),
  "b","p"),
  "c","u"),
  "d","d"),
  "e","J"),
  "f","v"),
  "g","r"),
  "h","j"),
  "i","f"),
  "j","i"),
  "k","e"),
  "l","b"),
  "m","w"),
  "n","B"),
  "o","'"),
  "p","g"),
  "q","s"),
  "r","o"),
  "s",";"),
  "t","N"),
  "u","["),
  "v","t"),
  "w","k"),
  "x","D"),
  "y","/"),
  "z","I"),
  "0","0"),
  "1","1"),
  "2","2"),
  "3","3"),
  "4","4"),
  "5","5"),
  "6","6"),
  "7","7"),
  "8","8'"),
  "9","9"),
  "10","10"),
  "A","n"),
  "B","G"),
  "C","S"),
  "D","X"),
  "E","U"),
  "F","Y"),
  "G","x"),
  "H","Q"),
  "I","h"),
  "J","M"),
  "K","y"),
  "L","+"),
  "M","z"),
  "N","A"),
  "O","""),
  "P","c"),
  "Q","E"),
  "R","q"),
  "S","P"),
  "T","m"),
  "U","{"),
  "V","V"),
  "W","K"),
  "X",":"),
  "Y","""),
  "Z","}"),
  "0","0"),
  "%","#"),
  "^","\"),
  "&amp;","|"),
  "*","!"),
  "(","("),
  ")",")"),
  "=","&amp;"),
  "+","O'"),
  "[","."),
  "]","]")
  </code></pre>