Skip to content
REFERENCE

U.REMOVE_NON_ASCII

Summary

Removes or replaces non-ASCII characters in cells

Syntax

=U.REMOVE_NON_ASCII(data, [trim], [ignore_part], [replacement], [remove_newlines_and_tabs])

Parameters

Parameter Required Description
data Yes The data whose values should have non-ASCII characters removed or replaced
[trim] No If set to TRUE then whitespace is removed from around result. Provide 2 values to separately specify trimming start of value and end of value, respectively
[ignore_part] No If set to TRUE then non-ASCII characters occurring after the first ASCII character and before the last ASCII character are not removed or replaced. Provide up to 3 values to set the ignore rule for the middle, start and/or end section of the value, respectively
[replacement] No If set then non-ASCII characters are replaced with specified value instead of removed. Provide up to 3 values to set a replacement for the middle, start and/or end section of the value, respectively
[remove_newlines_and_tabs] No If set to TRUE then tab, newline and carriage return characters are treated like any other non-ASCII character By default they are not removed or replaced

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.REMOVE_NON_ASCII($B$6:$B$7)

=U.REMOVE_NON_ASCII($B$6:$B$7,TRUE)

=U.REMOVE_NON_ASCII($B$6:$B$7,TRUE,TRUE)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.