Downloading to Excel from Database

kikik

New Member
Joined
Dec 19, 2005
Messages
31
I downloaded two databases (different sources) but the names are spelled the same. I trying a vlookup to match each name. The problem I'm having is that after each name there are spaces. The spaces differ from each file therefore, I cannot match the names.
How can I do vlookup or delete the spaces after each name?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,094
Members
412,766
Latest member
BigRusty82
Top