Select Page

px to vmin

To convert pixels (px) to the vmin unit, you need to know the viewport's minimum dimension. The vmin unit is a CSS unit that represents the smaller value between the viewport's width and height. For example, if the viewport is wider than it is tall, then 1vmin will...

How to Use Vlookup Function in Excel With Example

Vlookup function name stands for “vertical lookup” and is a function in Microsoft Excel used to search for specific information in a table or range of cells. It searches for a value in the leftmost column of a table and returns a value in the same row from another...

Excel Shortcut Keys to Speed up Your Work

Navigation Shortcuts CTRL + LEFT/RIGHT/UP/DOWN: Move to the next populated cell CTRL + END: Move to the last populated cell CTRL + HOME: Return to Cell A1 CTRL + G: Go to a specific cell by entering the address CTRL + PAGE DOWN: Go to the next spreadsheet CTRL + PAGE...

Count number of words in cell

Here is a quick solution for counting number of words in given cell. There is picture with example and belov is formula that you can paste into your Sheet, and just change cell that you want to count words. Example for getting number of words in cell A2:...

Extract Number in String

Vba function val() have property that help you to extract number from string. Here is code and exampe:   Function ExtractAmount(data As String) As Variant Dim s As String s = Split(data, "$")(1) 'part after first dollar...