Hello,
I have just taken on some admin related work at my work and have to cut and paste information from emails sent from the website into a spreadsheet.
The emails have several lines and a dummy example is below:
Booking ID: 1111111
Customer: John SMith (Company: Smiths)
Agent: Me
Venue: Somewhere
Site: Some site (1111)
Booking period: 01/01/2000 - 01/02/2000
I then highlight this info and copy it then go to paste this all in one cell in excel but no matter how i try this it paste in to several cells in the one column. I have tried paste/paste special and all the 3 options it gives and the same result happens each time.
A work around i am using currently is to paste it in to notepad and remove the returns (/n new lines) but this is time consuming and i need to be able to do this quicker.
Is there a way to paste all this info into one cell without using notepad?
Would i be able to write a VBA script to do this for me (not that i have time to do this right now)?
This is run on XP SP3
Regards
Spoff