How-tos - Sharing Tips and Tutorials for Microsoft Office
Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.
-
- Round up in Excel - A complete beginner's guide
- Excel absolute reference (how to make and use)
- 5 ways to transpose data in Excel (Step-by-step tutorial)
- Lock and protect cells in Excel – (Easy step by step tutorial)
- 5 Methods to Move Columns in Excel – Step by Step Tutorial
- 4 Easy Ways to Add Columns in Excel (Step by Step)
- Calculate days between two dates in Excel (7 examples)
- Easily count unique and distinct values – 6 examples
- Calculate Percentage in Excel – with 7 Formula Examples
- Freeze rows and columns in Excel (Easy tutorial)
-
- How to copy Excel page setup to other worksheets in Excel?
- How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?
- How to print ranges in Excel?
- How to add text to the beginning or end of all cells in Excel?
- How to count and sum cells based on background color in Excel?
- How to combine multiple workbooks into one master workbook in Excel?
- How to quickly apply formula to an entire column or row with/without dragging in Excel?
- How to convert birthdate to age quickly in Excel?
- How to extract text before/after space or comma only in Excel?
- Merge and Combine Columns without Losing Data in Excel
-
skyyang posted a comment in Easily detach attachments from emails in outlookHello, Marek, Thank you for your comment. I have forwarded your requirements to the developers, and if there are any updates, we will inform you immediately. 🙂about 3 days ago
skyyang posted a comment in How to send an email to multiple recipients individually in Outlook?Hello, Mahajan Thank you so much for your comment! We're thrilled that you are satisfied with our website. If you have any further questions, please don't hesitate to reach out.about 3 days ago
skyyang posted a comment in Remove middle name from full name in ExcelHello, Henry, To solve your problem, the following formula may help you: =TRIM(LEFT(A1,LEN(A1)-LEN(MID(A1,SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))),LEN(A1))))) Please have...about 3 days ago
henry posted a comment in Remove middle name from full name in Excelthank thank you!!!!!! been looking hard for this formula. However, what if there are commas? for example DOE, JOHN E. and I just wanted to remove the Initial? Also there are some Last names that are 2...about 4 days ago
Dnyaneshwar Mahajan posted a comment in How to send an email to multiple recipients individually in Outlook?I was thrilled to find this fantastic website. I must express my gratitude for taking the time to write this very amazing article! I really appreciated every part of it and already have you bookmarked...about 4 days ago
Marek Król posted a comment in Easily detach attachments from emails in outlookIs it possible for the programme to automatically create a subfolder by giving it a sender name?about 1 week ago
Anna posted a comment in How to automatically link a cell color to another in Excel?Hi Dear. sadly didnt take Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("G41")) Is Nothing Then 'Update fill color of cell C5 in "Blanko VGL" worksheet Workshe...about 1 week ago
Venkat posted a comment in How to auto create a dear sender’s name when replying message in Outlook?Hi skyyang, I need the macro to insert only the first name of the person I receive the email from. Not all the names from CC, but not to remove anyone. Also, to maintain my default color scale (R: 31...about 1 week ago
skyyang posted a comment in How to extract first letter of each word from cell?Hello, Sharmane Maybe the following code can help you: Function GetFirstLetters(rng As Range) As String Dim arr() As String Dim i As Long arr = VBA.Split(rng.Value, " ") For ...about 1 week ago
Ehrin Pitts posted a comment in How to change the default time for delay delivery in Outlook?I found that when you send an email on Sunday it is push to a week out as xMail.DeferredDeliveryTime = (Date + (vbSaturday - xWeekday + 2)) & " " & xDelayTime ends up with 8 days in the future instea...about 1 week ago
