User Profile
nickcicc
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
My online Outlook Calendar has reverted the old look and feel - why? Has anyone elses?
For the last 3-4 days, logging onto 365 to view my calendar has shown that the Calendar look and feel has reverted to the "old OWA style" calendar. I no longer see the new look calendar that has been in place for the last 6 months or so since Microsoft updated Outlook and Calendar online. Has anyone else had this experience? Support are flailing and seem unable to restore the new look calendar for me.999Views0likes1CommentNew Spill function making concatenate output difficult?
I'm no Excel whiz, but I need to be able to concatenate the contents of cells in 9 columns into one, for each row in a 1000 row spreadsheet, with comma-delimited output. I used to be able to do this quite easily up until the most recent Excel update. Now, the concatenate function uses Excel's new "SPILL" function to paste the result into adjoining empty cells next to the one I am placing my formula in. Isn't the reason for Concatenate to join the selected cells text into one cell? Anyway - I have not found a way that I can bring the output back into just one cell. I need to be able to copy these outputs into another spreadsheet, and while highlighting a cell in the spill output shows the blue outline for the range, copying the first cell only copies the first cells contents. Can anyone help?Solved29KViews1like6Comments
Groups
Recent Blog Articles
No content to show