I have the following data in one column. now on the next column, the following shall be met:
been using formula and contain but I really couldn't get it right, any help is MUCH appreciated!
column A |
ABC1234 |
1234 |
BD1234 |
12345 |
Solved! Go to Solution.
Hey @fabs, how does this look? Works for your example but let me know if there are any issues when testing! Workbook attached.
Edit: If there are instances where there may be records with special characters or non-alphanumerics then I've added another rule to catch and null these. If you'd rather they were labelled instead then just replace the null() with 'D' for example.
@DataNath HUGE thanks man!!! 😎 Just had few additional roadblocks tho. There some cells that says "UNKNOWN" and that should be valued to C. and if column A is blank, column B should also be blank.
I tried adding Contains(column A, "UNKNOWN") after Startswith function, but it's still returning "A" value. and for the null values, its giving me "B" value, but it should remain as blank.
No worries @fabs - thanks for the clear explanation of the rules! How does this look? Amended workflow attached.
this helped a lot! thank you so much!!!!!!!!!!!!!!!!!