PowerUp Description

The pwrISADDRESS PowerUp function determines whether the value or reference matches the expected pattern of a complete postal address.

PowerUp Syntax

pwrISADDRESS(value)

The pwrISADDRESS PowerUp function has the following arguments:

value – Required. This is the value or reference to a value to be evaluated for a postal address pattern match.

Return Value

pwrISADDRESS will return TRUE if the value matches the pattern for a postal address.

Remarks

The value is not validated to be an actual, reachable postal address. The pattern is checked to verify that it is a potential postal address.

Example

=pwrISADDRESS("PO Box 1234, Anytown, WA 99163")

Leave a Reply

Your email address will not be published. Required fields are marked *