I've picked up a few tricks for doing this like TRIM/power query but I'm curious if anyone else has some additional tips/tricks. Any youtube video I've seen on the subject has used pretty "clean" excel docs. Anyone who has received PDF versions of rent rolls knows what I'm talking about... Tragic
| +43 | What Is Your Backup Plan? | 20 | 14h |
| +39 | Where are free agents signing? | 21 | 20h |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 18h |
| +34 | Future of Real Estate | 9 | 23h |
| +31 | Laughable Job Posting | 12 | 16h |
| +16 | Extremely Slow Ramp Up | 1 | 2d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 2d |
| +10 | Dynex | 5 | 1d |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Just at a curiosity, what function are you using?
TRIM() is great to remove excess/unwanted space
Text to columns is another great tool as well to split up data that got mashed together
I'm a bit of a noob w/ power query but I've found it useful for cleaning out useless data
From, adventures in CRE, I learned a pretty slick way of gathering all market rent/in-place rent from a MF rent roll using index/match
Simple copy and paste w/ transpose is also pretty useful
I am by no means an expert in Excel, but as simple of a function as it is, I have been using the snipping tool for PDF rent rolls and importing the picture through the "From Picture" function and producing really clean data. It's been crazy easy with certain RR's.
That's fucking NUTS. I'll have to give this a shot. Do you have any examples you'd be willing to share?
I am not sure with confidentiality agreements that I am able to share anything. But, it is really simple and I have had lots of success using that feature. What I did before that was uploading the PDF into Adobe and then selecting each row in a big data set and inserting it row by row, which was effective but incredibly inefficient for large data sets.
With this market you gotta just scrap the deal when broker sends PDF RR
I work in brokerage and the amount of PDFs I receive from clients is unreal lol
Able2Extract is the best PDF to excel converter I have come across. It's $150/year, but well worth it.
No. Merged. Cells.
Ut et quia tempora porro numquam. Similique ut rerum autem qui animi. Quod dolore et nesciunt cum vel non quo. Dolor optio accusantium consequatur veniam sed ab voluptates corporis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...