for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

GeneHunt59 Oct 2024 12:45pm, 9 Oct 2024 3,879 posts	Quote Pin GeneHunt59 Thanks @larkim @CBN @um for your prompt replies. I tried CBN's first suggestion first and it worked perfectly.
GregP Oct 2024 5:12pm, 22 Oct 2024 153,906 posts	Quote Pin GregP Why Microsoft Excel won’t die economist.com from The Economist
GlennR Oct 2024 6:47pm, 22 Oct 2024 76,777 posts	Quote Pin GlennR Bit harsh to suggest that Excel was to blame for the Covid analysis fiasco. That was down to halfwits using antiquated versions of the program. Good article though.
JamieKai chameleon Oct 2024 4:34pm, 30 Oct 2024 19,445 posts	Quote Pin JamieKai chameleon OK, not Excel at all, but I'll bet someone here is a PowerPoint wiz. I'm putting together a presentation aimed at being a bit of a training aid for recording report proposals for court reports. I have 11 different screenshots for 11 different proposal elements, and rather than force it to show each one in turn, I'd like the user to be able to select the element they want to see (for example, using a menu at the side of the slide) and for the screenshot to appear. Is this (easily) doable?
run free Oct 2024 4:57pm, 30 Oct 2024 5,385 posts	Quote Pin run free Yes. You can save it as a PDF and either use a PDF reader or post it online onto a web page
run free Oct 2024 4:58pm, 30 Oct 2024 5,386 posts	Quote Pin run free The other thing you can do is to use action buttons to go to each proposal and drive it from a front slide
larkim Nov 2024 2:30pm, 11 Nov 2024 26,072 posts	Quote Pin larkim How would you go about converting dates in the following text format to something that Excel can handle? 3rd Sep 2015 6th Nov 2015 1st Jan 2022 25th Dec 2015 Stripping out year is simple with a right([ref],4) and I think I can use =find(" ") to back-calculate where the date integer is and lose the "th" or "rd" etc. What about the truncated month?
SPR Nov 2024 2:32pm, 11 Nov 2024 46,699 posts	Quote Pin SPR What happens if you wrap the text in Value?
larkim Nov 2024 2:45pm, 11 Nov 2024 26,073 posts	Quote Pin larkim I get #value errors in that scenario. I found =MONTH(DATEVALUE(A2&1)) worked in the end to parse the three letter month string once I'd stripped it out, though not entirely sure I understand why! Just very messy to work with all the parsing, especially as the format I've got could equally be outputted by Excel by using a formatting mask.
SPR Nov 2024 3:00pm, 11 Nov 2024 46,700 posts	Quote Pin SPR If st/rd/th was removed, Value seems to work on a date in Text so I'd probably have gone for something live that, would probably still be messy though.