Thats where I am. Already copied it to excel. The data is supposed to be in 3 columns but as in the illustration I gave, its all in one column. I want some form of algorithm to create 3 rows (for name, date and dept) and populate the details below those columns. Without having to copy/paste On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <wayodi@gmail.com> wrote:
You can try saving it as a CSV file, then working on it from there will be easier/
On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
It was supposed to be sent in a tabular format but for some reasons (blame my email client) this is how it appears on my screen:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke