Hi,
There is a very useful report that our system can generate, unfortunately it doesn't let us export it (so only useful for very specific searches, but I want to be able to use it for large data sets). As a work around I've Printed to PDF and converted it, however it all comes out as one cell
The output looks like this..
How do I go about splitting this out? Each basic field that is changed will have it's own line, in the above there's 2 but it can be more/less, I need to get each one into it's own either row or column (I can work with either, but row would be a preference)
I'll then have the date and CAN- ref in another (I've managed to do that bit), and this will give me an incredibly useful list I can lookup and manipulate for several projects I have lined up.
I've tried Google and it talks about a split cell feature, but doesn't seem to be an option in Excel 2019 that I can use
Any help would be hugely appreciated!
There is a very useful report that our system can generate, unfortunately it doesn't let us export it (so only useful for very specific searches, but I want to be able to use it for large data sets). As a work around I've Printed to PDF and converted it, however it all comes out as one cell
The output looks like this..
| Wednesday 17/02/2021 10:21:47 Chris M Amend | The candidate record ''CAN-12345'' (John Doe) updated, overwriting the previous update by ''Chris M'' at ''17/02/2021 10:03:57''. Changes made to basic fields -> Candidate Status: "Pre-screened" -> "Placed by Us" Candidate Compliance Consultant: "Chris M" -> "Joe Blogs" |
How do I go about splitting this out? Each basic field that is changed will have it's own line, in the above there's 2 but it can be more/less, I need to get each one into it's own either row or column (I can work with either, but row would be a preference)
I'll then have the date and CAN- ref in another (I've managed to do that bit), and this will give me an incredibly useful list I can lookup and manipulate for several projects I have lined up.
I've tried Google and it talks about a split cell feature, but doesn't seem to be an option in Excel 2019 that I can use
Any help would be hugely appreciated!
