In this video demo I'm going to show you how use VLOOKUP on a table in Excel. In order to see the text clearly, please set the video to one of the two HD options using the gear icon. Attachment: Using the VLOOKUP Function

In this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …

This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping …