仙台城 – 伊達獨眼龍政宗

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?

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 [...]