How to find specific column contains alpha or numeric

Question

Hi,

I need to find specific column contains alpha or numeric, refer sample data.

where Column 5 Alpha should only contain Alpha only, else it should show "Invalid Alpha"

Example - Row 1 = ABCDF = Valid

Row 2 = SHJ3F = Invalid Alpha

Similar in Numeric as well.

Where Column 4 Numeric should only contain numeric values only, else it should show "Invalid numeric"

Example - Row 1 = 7686 = Valid

Row 2 = 125U = Invalid numeric

Thanks in advance

Sample data.xlsx

New Workflow.yxmd

IraWatt · Accepted Answer

Hey @Khanzali007,

I would use the formula tool using the Regex Match function which checks if all the characters are digits or alpha:

Any questions or issues please ask :)
HTH!
Ira

binu_acs · Accepted Answer

@Khanzali007 one way of doing this