Marie has attended:
Excel Intermediate course
Separating block of text into columns
Hi, I have a very long list of info on a pdf that is separated in headings ie name; address; tel. When I copy and paste it to excel, they merge together into one column. How do I keep them separated please? I've tried pasting them to notebook first but didn't help. Thanks.
RE: Separating block of text into columns
Hi Marie,
Thank you for the forum question.
When you copy from a text document or PDF the text is not organised in columns but only in lines.
That is the reason for you get it in Excel in one column and many rows.
Try the Text to Columns tool (see my other answer). If it is not working Excel can only help you (and it will be complicated) if there is a clear pattern in you data. A pattern could be that all the names were one first name and one last name.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
