[Excel] Formula to extract email from a cell

-
This is a useful formula to extract an email out from the string in a cell.

=TRIM(MID(SUBSTITUTE(" "&$A1&" "," ",REPT(" ",40)),FIND(REPT("@",COLUMNS($A1:A1)),SUBSTITUTE(SUBSTITUTE(" "&$A1&" "," ",REPT(" ",40)),"@",REPT("@",COLUMNS($A1:A1)),COLUMNS($A1:A1)))-40,80))

:)

Comments

Post a Comment

Popular posts from this blog

[Magento] Create Contact Form with Dynamic Recipient

-
There are many ways of creating contact forms to email to multiple recipient. I'm going to describe a way that uses Javascript a the frontend to change the target recipient. Advantage of this method: Easy to add in new emails in the future. Disadvantage of this method: For those who are particularly concern email privacy, you might not want to use this method. You can modify the email checking to the backend (controller) instead. Okay enough talking, lets get started. Step 1: Set up HTML form fields I'm going to use an example of drop down select to change the email. Of course, this is fairly easy to modify with other forms as well. Open up app/design/frontend/default/<theme>/template/contacts/contacts.phtml Insert the following snippets anywhere between the <form>...</form> tag. <select name="interest" id="interest" title="<?php echo Mage::helper('contacts')->__('Please select department t...
Read more

bin/sh^M: bad interpreter: No such file or directory

-
Tried to install DirectAdmin on Ubuntu just now but encounter the following error. ./setup.sh: /bin/sh^M: bad interpreter: No such file or directory A quick Google search revealed that dos2unix can fix the problem. sudo apt-get install dos2unix Then fix the problem by. This will convert the file to unix format. dos2unix setup.sh Then just execute the file as per normal.
Read more