Eloise T
Active Member
(See macro line below) CLEAN takes care of ASCII 0-31 and TRIM takes care of extra spaces but I also need to remove ASCII char. 160 as well.
Is it possible to add "remove ASCII character 160" to the following line and if so, how? ...or I'm also open to an alternate suggestion to accomplish the same thing.
.Value = .Parent.Evaluate(Replace("IF(#>"""",TRIM(CLEAN(#)),"""")", "#", .Address))
Thanks in advance.
Is it possible to add "remove ASCII character 160" to the following line and if so, how? ...or I'm also open to an alternate suggestion to accomplish the same thing.
.Value = .Parent.Evaluate(Replace("IF(#>"""",TRIM(CLEAN(#)),"""")", "#", .Address))
Thanks in advance.
Last edited: