Recent Discussions
REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, Anupam
Markup Panel appearing with every word document. Comments column now in some weird thing.
Good day, I am so confused I do not even know how to explain all the issues. 1) Opened a word document today that I closed yesterday. Opens up with some thing called a Markup Panel. Go to review and select no markup. Fine for now, but then appears every time I reopen the document, and all other documents. 2) Up until today, my comments were nicely formatted in a column on the right side of the screen. Now they are in some thing called a "reviewing panel" which is terribly formatted and located in the wrong place until I drag to to the right side. Is this something I have caused or some Word Update (God, I hope it is not the latter.) 3) Also, the little indicators next to the lines where the comments are located are no longer present, so the only way I know there is a comment on that line is by clicking on the comment in the stupid "reviewing panel" How do I get back to what I had yesterday? Thanks so much for your help. Dave
Delete Empty Rows ONLY
I saw someone else's post, but nobody addressed the problem. Their solutions delete every row that contains a blank cell. I want to delete ONLY the rows that are COMPLETELY blank. The top rows are what I want it to resemble. The bottom several green blank rows are what I want to batch Delete.
Filter function with a criteria
Dear Experts, I have a data like below( in columns A/B/C) , and needed the result in column (I/J/K), but I could achieve only like in Column (E/F/G) For example for the rnti = 19453, the corr0 , at time -> 06:34:32.171912 is not there so at Row-3, the entry should be empty Attached is the worksheet, Br, AnupamHelp with formula
Hello! If I'm trying create a formula that pulls data from one sheet into another. I want it to pull in data in column E if column B has a january date AND column C has the word discover in it, into another tab within the same workbook. The formula below works perfect but the only problem is it has to be only the word "discover" (yellow cells) in the cell, if it says "discover - food" (green cells) it doesn't pull. Is there a way to have the formula pull the data if the word "discover" shows in column C but with other words like in the green cells? My current formula that kinda works: =INDEX('My ✓ing'!E:E,MATCH(1,(MONTH('My ✓ing'!B:B)=1)*('My ✓ing'!C:C="Discover"),0)) Pulling from this sheet below Into this sheet in the same workbook. The yellow ones work because it just has discover, the green is not cause it has Discover - food. Is there a way to get it to search for the word discover and not necessarily match? Thank you for any help!Error installing Apps 365, command not supported.
I was performing an Online Repair for a user. It did the uninstall fine, but then threw this error. I tried to reinstall, same error. Used the MS Cleanup tool, ran SFC, cleared temp files, cache... Internet connection is stable. Disabled security software (Zscaler). I'm out of ideas. I'm hoping someone has seen this before. Thanks for any help!
Recent Blogs
- We’re making changes to the Microsoft 365 Copilot app for iOS that put key AI-driven capabilities and experiences front and center.Sep 17, 2025
- New Outlook for Windows has top-requested capabilities like pin important emails, add shared mailboxes as accounts, and newsletters.Sep 16, 2025
