![]()
This is actually pretty simple, but this particular challenge is a little more interesting as the type of non-alpha characters and the number of them used within any give address is unknown, so the formula must manage that as well.Īgain, the tactics used to solve this can be used in an infinite number of Excel scenarios that have nothing to do with email addresses. The challenge here is to create ONE formula that will work with first and last names of any length and that ONE formula can simply be copied down a column adjacent to the addresses. It is extremely unlikely that all of your addresses have John for the first name, or even a four-letter first name. Hardcoding splice points to a string is anything but generalized as your small sampling of formulas demonstrate. Perhaps you will never have such a dataset to work on, but the solutions shown here work in an infinite number of scenarios that have nothing to do with email addresses. Please try to accept challenges such as this one as an opportunity to learn by pushing your understanding.Įlegant solutions are concise but at the same time work over a generalized problem domain. Try this – more than 25 challenges and problems in Excel. Go ahead and liberate John Doe from We are waiting… Special note: If your formula contains symbols when posting it, use < and > instead.It will help rest of us understand and use your formulas. Tell us how you arrived at the formula, what it does. Just comment on this post with your answers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |