How-Tos - Sharing Tips and Tutorials for Microsoft Office

s2smodern

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.

Latest Articles

Latest Commented

crystal 51 minutes ago How to remove text before or after a specific character in Excel?

@ArtikHi Artik,
This formula can help you: =TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",LEN(A1))),LEN(A1)))

crystal 56 minutes ago How to add plus sign to multiple positive numbers in Excel?

@Mehedi HassanHi,
Maybe the method in this article can help: https://www.extendoffice.com/documents/excel/3087-excel-sum-adding-numbers-in-a-single-cell.html

Sunny 3 hours ago How to find nth occurrence (position) of a character in text string in Excel?

@NitishThe firs formula works correct in my version, in the note, it has explained how to find the third or forth or nth "c".

Note: You can change the 2 in the formula based on your needs. For example, if you want to find the fourth position of "c", you can change the 2 to 3. And if you want to find the first position of "c", you shuold change 2 to 0.

Sunny 4 hours ago Wie fügt man in Excel Text am Anfang oder Ende aller Zellen hinzu?

@HeidiDanke für Ihre Anerkennung

Sunny 4 hours ago How to round number to nearest 5/10/50 in Excel?

@sachinSorry I have no idea.

Sunny 4 hours ago How to create a dynamic list of worksheet names in Excel?

@KellySorry, I do not find that code can finish your job.

Sunny 4 hours ago How to lookup a value and return cell address in Excel?

@bskSorry I have no idear.

Sunny 4 hours ago How to VLOOKUP with drop down list in Excel?

@TimSorry, I have no idea about this problem. maybe someone can help you if you carry on the problem in our forum https://www.extendoffice.com/forum.html

Sunny 4 hours ago How to auto insert row based on cell value in Excel?

@Himaybe this vba code can help you. It will add rows if above row is not empty

Sub helping()
Dim count As Long
For count = ActiveSheet.UsedRange.Rows.count To 1 Step -1
If Information.IsEmpty(Cells(count, 1)) = False Then Rows(count + 1).Insert
Next count
End Sub

Sunny 5 hours ago How to convert date to number or text in Excel?

@LothianYou can try to format the date cells as custom, and type yyyy-mm-dd into the Type textbox in Format Cells dialog. If you want to know more detail, this is an article talk about three ways to convert dates to yyyy-mm-dd. https://www.extendoffice.com/documents/excel/3289-excel-convert-date-to-yyyy-mm-dd-format.html