this is what I have while looping. it's a mess.


  f = "a" & myArray(x)
          f = Replace(f, vbLf, "")
          f = Replace(f, " ", "")
          f = Trim(f)
          f = Application.Trim(Application.Clean(f))