Split email username and domain name in Excel

December 9, 2011 11:42

How to split email username and domain name to two cells in Excel? Suppose the email address is in A2 cell. Grab domain name from email =MID($A2,FIND(“@”,$A2)+1,LEN($A2)-FIND(“@”,$A2)+1) Grab username name from email =MID($A2,1,FIND(“@”,$A2)-1) Easy, right?

Comments Off

Reading from and Writing to Excel in PHP

December 4, 2003 21:57
Tags: , ,

One interesting implementation for the latest project I’ve got is to read some Excel file using PHP and stores the data in MySQL database, then exports the data to Excel, PDF or HTML format. There are so many various solutions. After I searched many websites and forums, I got some answers – use PHP Excel [...]

Comments Off