HOW TO Subscribe to HOW TO

You can use a VBA script to combine rows into one cell separated by commas, instead of using Paste Special > Transpose and having to edit the Concatenate function every… Read more »

Here are some standard printing format tips. Go to _File –> Page Setup_ then… •To shift between Landscape vs. Portrait: ◦Click “Page” tab and select desired layout. •To fit your… Read more »

Uses: if you do something often, you can record your own macro to create a shortcut for what you do. You can save it just to the sheet you are… Read more »

1.First, save this file in your desktop (right-click and choose “Save Link as…”): •surfermacros.xla: surfermacros.xla 1.Open Excel 2007 and click on the big Office 2007 button at the top left…. Read more »

Recently, someone asked me if it is possible to use VLOOKUP to restore a list of values that has been partially reduced and resorted so the list will restore the… Read more »

Use: to look for certain values in a column and return a value in another column. This function can be used as a way of deduping, but it is complicated… Read more »

Use: to get rid of (i.e., trim) all extra spaces, except one space in between words. It will delete all spaces before and after the words in the selected cells…. Read more »

The Sum function is one of the easiest functions to use and is very straightforward. It will add up the cells you selects. To do the sum function you can:… Read more »

Use: to get a quick idea of how many entries are in a column, a row, or multiple columns/rows. 1.Highlight your cells, column(s), and/or row(s) 2.At the bottom left of… Read more »

Use: to merge data from different columns into one string in one column. Good to prepare data for uploads to a database (Hotlist, Milton, Harmony, IY, etc). Also good to… Read more »