• Home
  • About
  • Appearances
  • Contact

hemmans.com

fresh insights on technology

Use the Lookup feature to find values in lists with vLookup in Excel

Posted September 12th, 2008 in Excel 2003

You can use VLOOKUP or HLOOKUP to find corresponding information in a list of data, either vertically (VLOOKUP) or horizontally (HLOOKUP).
The VLOOKUP function scans vertically down the leftmost column of data, looking for a match to the input you provide. Upon finding a match, VLOOKUP returns a value from the given row, corresponding to a [...]

Read more | Leave a Comment


Combining data from multiple cells with Concatenate in Excel

Posted September 12th, 2008 in Excel 2003

Excel gives you the ability to combine text from multiple cells into a single destination cell.
For example, if you have a cell that contains a first name and another cell that contains a last name, you can combine those cells together and also include arbitrary strings of characters such as a spaces (“ ”), or [...]

Read more | Leave a Comment


Distributing data across columns with Text to Columns in Excel

Posted September 12th, 2008 in Excel 2003

In Excel, you can take a cell and split its text across columns in a number of ways. The easiest of these is to use the Text to Columns command under the Data menu in Excel.
For example, if you have a cell that contain both first and last names, you can use the Text to [...]

Read more | Leave a Comment


Paste the resulting values, not the formula with Paste Special in Excel

Posted September 12th, 2008 in Excel 2003

Occasionally, you may need to use a formula to change the way data appears. And, it is often handy to be able to extract the resulting value of a formula, but not the formula itself.
For example, you can use a formula to remove extra spaces from data. If you then wanted to split the [...]

Read more | Leave a Comment


Removing extra spaces from cells with Trim in Excel

Posted September 12th, 2008 in Excel 2003

If you have data that contains additional spaces, there is a function you can use to trim them out.

Select a destination cell for your formula.
Type =trim([cell name]), then press Enter.

Note: According to Excel’s Insert Function dialog box, “Trim removes all spaces from a text string except for a single space between words.”

Read more | Leave a Comment


« Older Entries
   
Newer Entries »

hemmans.com is powered by WordPress
Entries (RSS) and Comments (RSS).