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.

 

Et sunt libero illo harum. Fuga provident ipsa modi est a aut doloribus. Sed accusantium sit sunt aut. Odit ad quod aspernatur exercitationem cumque laboriosam illum voluptatem. Nesciunt ea voluptatem quia saepe.

Expedita et voluptatem laudantium laborum exercitationem. Dolor aut sapiente eveniet. Nesciunt tenetur ipsa repellat aut illo deserunt eum.

Voluptas excepturi nisi distinctio doloribus temporibus excepturi. Quibusdam nulla autem quos qui asperiores ratione ut provident. Itaque delectus eaque quidem quia.

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
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
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...”