This formula will give you a clean base path of a given URL Example: URL Just Domain Base Path http://www.amazon.com/Totally-Free-kindle-Books/lm/R27UG52OAM3TFX amazon.com www.amazon.com
Category: Excel
Excel – Get Worksheet Name
If you’re like me you name your worksheets in Excel to help make more sense of the data. I try to incorporate a universal header in most of my Excel documents so this script helps me. Example: Say you have an Excel file to log all the domains you manage…
Excel – VLookup – Unique Join WorkSheets
Sheet1 Column A Column B Moo ./.htaccess Sheet2 Column A Column B ./.htaccess 235 Add the code above to Column C in Sheet1 and it will match Column B from Sheet1 with Column A from Sheet2 and get the value to display from Column B from Sheet2
Excel Rand
Great if you are creating random passwords, more examples at the reference link below. Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html
Excel – Find Comma Replace With LineBreak
Selected the range of cells you need to replace. Go to Home > Find & Select > Replace or Ctrl + H Find what: , Replace with: CTRL + SHIFT + J Click Replace All Somehow CTRL + SHIFT + J is registered as a linebreak. Reference: http://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell
Excel Macro – Autofit width and height
AutoFit() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+d to select all columns and rows and then set a temporary width and height to then autofit based on all the content in the worksheet. AutoFitHeight() is designed to run in your Personal.xlsb with a keyboard…
Excel – VLookup – Compare Two Columns/Sheets
Sometimes we need to compare lists in Excel, this function will assist in getting a clean comparison. NOTE: It is best when comparing that all columns are same format (ie. Text, Number, etc.) Going one step further, if you find a match and need a value from the other worksheet…