Just enter the numbers you lazy little...

JK - can you be more specific about what you're trying to do? I think "text to columns" is worth a google if you don't know about that yet (sorry I am going off your 1992 as potentially a birth year and thinking you are a junior-ish analyst or SA, so please don't take offense if you've tried this already).

if you like it then you shoulda put a banana on it
 

Alt plus highlight using the mouse to copy multiple figures. Then paste into excel using text to cell delimiting which I usually do in a blank throwaway spreadsheet before copying over to avoid any weird ongoing side effects of the text to cell delimiting.

 

The only way I could figure out how to do it (aside from buying one of the conversion packages), was copy paste it all. It will look like a mess, but I believe you can sort it out a little if you go to Data ribbon -->Text to Columns tab and fiddle around with those settings.

People demand freedom of speech as a compensation for freedom of thought which they seldom use.
 

If you're good, you could create a macro that should be able to take everything out of the one individual cell and then place it in to a table.

make it hard to spot the general by working like a soldier
 

Under the 'Data' tab, there are a couple of options that might help you. Maybe try import data "from Text" or "text to columns"?

Alternatively, if it's like a research report, it can't hurt to actually email the analyst and ask for his model.

 

Xpdf at: http://www.foolabs.com/xpdf/

it's a command based thingy, very-very simple to use and works wonders converting pdf tables to txt (which you can then import to excel).

learn how to use it and you'll save yourself heaps of trouble.

there are also other software apps around that are good - depending on what you're dealing with, you'll need to try them out until you find what works for you.

 
hoodinternet:
I tried out XPDF but I can't get it to work... I know its a command based thing but I can't get the .exe file to open, any suggestions?

copy/paste the pdf you want to convert in the same folder as the xpdf utility, open a cmd.exe window, go to the folder where you have installed the xpdf utility through the cmd window (i.e. cd folderx, cd xpd blahblah) then type pdftotext -layout mypdf.pdf look into the folder for your new mypdf.txt file

that's all. Read the pdftotext.txt file for more info.

 

There are many third-party tools available in the market that convert PDF to Excel format. I recommend Stillbon PDF to Excel Converter Software. This tool can easily convert your pdf file to excel file quickly. This tool has a very easy interface that everyone can use without having any knowledge of the software.

 

Voluptas vitae repellat deleniti et vel cum odit. Ea officia voluptatum blanditiis consequatur exercitationem atque veniam. Nihil omnis numquam debitis aut sed ex. Commodi beatae quasi iste harum enim. Facilis excepturi id omnis veritatis cupiditate necessitatibus in. Sunt sint sit nemo veritatis corrupti.

 

Dolores perferendis est omnis deleniti labore eligendi quia nulla. Beatae hic atque dolorem dolores. Numquam enim hic quo dignissimos velit ut nihil.

Possimus corporis necessitatibus eligendi corrupti eum hic eos cupiditate. Id in enim doloremque ea nobis nulla id. Aliquam quis nulla itaque. Doloribus sit cum aliquam laborum.

Sed quia est quo incidunt ad itaque. Rerum ut et illum porro natus at. Repellendus qui quia cupiditate incidunt fuga et vero ipsa. Recusandae architecto laboriosam soluta qui ipsum qui laudantium.

Dolor ex nisi numquam. Voluptatem voluptas dolorem sunt libero accusamus. Quia velit velit enim aut sunt. Voluptate rem ut consequuntur vel eos in.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
kanon's picture
kanon
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”