Recent content by paconovellino

thanks Andy!

Hi, and thank you so much for your replys. I need the information to be displayed as SkipVought mention on his second replay.

The result should look something like this Date: 09/08/13 1536 Avalos, Rodolfo Client Training 10:00 Date column B, Id column C, Agent Name Column D, activity Column E and Total time in activity Column F Thanks

I want to extract the date, the agents ids (number next to name), the agent's name, the activity (client training)and the total (10:00) on different columns and repeat it until all data is formatted. Thanks :)

So far I got this macro that I found on the internet, but I cant get it to get the date Sub JobsAndPercentsByName() '//Sub will strip out from a single column: '1) ID and Name '2) Job '3) Time '4) Percent of Time '//ASSUMPTIONS: 'Column A and only column A is populated 'Row 1 starts...

I have a problem with a lot of text that can only be imported to excel into one column (A). The only problem is that it needs to be parsed and sorted by several different things. I have found it difficult to find any information on how to modify the information. This is how the text looks like...