Please forgive me as I am no expert in excel. I an a total n00b when it comes to formulas and excel stuff.
What I an trying to accomplish is locate cells that has 5 or more numbers inside it. I am working on email addresses and want to identify those cells. Im just working with A column only so column B would say true or false.
example: my12345(at)exampl.com or 5738654example(at)email.com
Thank you for your attention.
P.S. Im not yet allowed to post links or vids.
Hi and welcome
Try this in B1 and enter it as an array formula (press enter + control + shift) when entering it then drag down
=IF(SUM(IFERROR(VALUE(MID(A1,ROW(1:50),5)),0))>0,"TRUE","FALSE")
Happy with my advice? Click on the * reputation button below
Originally Posted by Crooza
Hi and welcome
Try this in B1 and enter it as an array formula (press enter + control + shift) when entering it then drag down
=IF(SUM(IFERROR(VALUE(MID(A1,ROW(1:50),5)),0))>0,"TRUE","FALSE")
Thanks a bunch. That did it for me. Rep added
No, because you are new - it's not allowed yet.
However, there are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Great. Glad it worked (and thanks for the rep)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks