Related Posts
April fools joke?
Not sure how one sleeps if this is true.
Additional Posts in Excel Genius
Google Sheets vs Excel - pros? cons? differences?
What are the most typical models you all build
I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?
New to Fishbowl?
unlock all discussions on Fishbowl.
Clarification: The org charts are images on slides in ppt and I just need to copy over the words (names, titles, managers…)
agreed. Certainly the original image creator had access to the data you’re after. Cut out the middleman (images in ppt) and go straight to HR for an excel-friendly export.
If you’re not permitted to have that data or the folks in HR don’t have a clue, try the folks who maintain Active Directory. They know how to give you an Excel-friendly data set.
But if you have my luck, you’ll be denied there as well. So then you will be stuck creating a table of your own, and 2 things are sure to follow:
1. Someone else will take credit for it, and
2. Your work will be appreciated and this manual and laborious task will be assigned to you for years to come.
Welcome to the club!