Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

TRIM

VLOOKUP Hack #8: Extra Spaces

By Jeff Lenning | December 12, 2017 |

Here’s a VLOOKUP question for you: What happens when the lookup value includes extra spaces? For example, a few trailing spaces, or leading spaces, or, extra spaces in the middle of the text string. When the lookup value has extra spaces, but the lookup range values don’t, VLOOKUP runs into problems. This leads us to…

Read More

Remove Extra Spaces from Lookup Values with TRIM

By Jeff Lenning | February 27, 2014 |

This post discusses one way to enable our lookup functions, such as VLOOKUP, to work even when the lookup values contain extra spaces. We’ll use the TRIM function to dynamically remove padding from the lookup values. Overview We’ll use a specific example to demonstrate this function. Let’s say we’ve exported a partial income statement from…

Read More