If a cell contains Text

[DodgerFH]

I am trying to clean some data before importing it into a file.  I CANNOT change the original source.   

Working on a Zip Code field,  but sometimes it contains letters for other countries.   Is there a way to highlight cells that contain text?  I am wanting to replace any cell that contains text with a zero.  Not sure how to specify in a formula that it is text.   

Any help appreciated

[alexnajm · Accepted solution]

IIF(Regex_Match([Field],".*[[:alpha:]]+.*"),"0", [Field])

[Carolyn]

RegEx! 

You can use RegExMatch to flag when text is present and then filtered for when a non-number is found (I used \D = not a number - it'll catch spaces and special characters too)

     REGEX_Match([Zip], ".*\D.*")

You can use RegExReplace to replace a non-number with a 0

     REGEX_Replace([Zip], "\D", "0")

See attached workflow example

[DodgerFH]

Thanks! This worked perfectly.   Really appreciate the quick response.  Have a great day! 

[Carolyn]

@DodgerFH - Yay, glad it worked for you! Please mark your question as solved. You should be able to "accept as solution" for the reply/replies that solved it. It makes it easier for others to go right to the solution if they have the same question :)