Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2021, 03:15 AM
Marcia's Avatar
Marcia Marcia is offline How to separate wrapped numbers copied from a PDF file Windows 7 32bit How to separate wrapped numbers copied from a PDF file Office 2013
Expert
How to separate wrapped numbers copied from a PDF file
 
Join Date: May 2018
Location: Philippines
Posts: 364
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default How to separate wrapped numbers copied from a PDF file

Hi. Related to my previous post on table headings as numbers, I downloaded the official table source from the issuing agency website in PDF format. I used the Adobe online in converting the pdf to Excel but got a horrible result. The values in rows 2 to 30 were wrapped in a single row.
My option is to manually copy the amounts into an Excel table but typo errors are highly possible.
Kindly suggest a quicker way on how I will separate the wrapped amounts.
Thank you.
Update: I found the solution from:
How to Split Multiple Lines in a Cell into a Separate Cells / Columns
After splitting the wrapped values through the Text to Columns tool, I then applied the copy>paste special>transpose.
Attached Files
File Type: xlsx WrappedNumbers.xlsx (11.9 KB, 1 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to separate wrapped numbers copied from a PDF file What wild card set up would separate a colon followed by letters but not by numbers? CrossReach Word 3 11-26-2019 04:31 PM
How to separate wrapped numbers copied from a PDF file Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? commissarmo Word VBA 3 03-14-2015 12:53 AM
How to separate wrapped numbers copied from a PDF file Copying a part of a docx file as a separate file officeboy09 Word 6 09-26-2014 05:15 PM
Separate/ Remove digits from a string of Numbers QA_Compliance_Advisor Excel 3 07-23-2014 04:59 AM
Separate heading numbers darksupernova Word 16 03-02-2013 06:09 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft