The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

TEXT TO COLUMNS IN EXCEL

TEXT TO COLUMNS IN EXCEL

0
Votes
1
Answer

Please I’m stuck here. How do I convert the text in the Excel sheet to columns as in the PDF file? Here are the PDF file and excel sheet https://photos.app.goo.gl/CMKWM7pkDmw9hcCK6

I’d really appreciate it if someone could help me out

1 Answer

365 Team
0
Votes

Hi Gbolagade!
Thanks for reaching out.
Perhaps what you can do is first make sure that you’ve applied border color to the cells that will compose your table.

Then, Go to File/Export, and select Create PDF/XPS.

This will create the PDF file you are aiming for, I believe.
Hope this helps.
Best,
Martin

×
Ready to Learn
Data Science?
50% OFF