How to find specific column contains alpha or numeric

[Khanzali007]

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

[IraWatt · Accepted solution]

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

[binuacs · Accepted solution]

@Khanzali007 one way of doing this

[Khanzali007]

@IraWatt @binuacs  Thanks for the solution. Both works fine.

Thank you.

[IraWatt]

No worries @Khanzali007 😄