Excel Export problem with VLOOKUP

jfletcha

New Member
Joined
Dec 12, 2005
Messages
1
Hello!

I am experimenting with Vlookup to utilize a database of item (pulling item information via the item number). I figured that out, and it works fine.

I am having one problem with the exported database (exported from a program that holds all of this information)

In a column with a UPC code, there is also a space below, as if I had pressed return in the cell. THis is not too noticable in the original database, but when VLOOKUP pulls the information it adds a Square character after the UPC (and other column information). I could go through an manually delete each of these, but there are thousands of them, and this would obviously take a very long time. Is there some way to remove these 'returns' from the cells?

Oh, Find and Replace DOES NOT work, as you can't type or paste a return to search.

Thanks, I hope there is a solution out there =)
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,118,436
Messages
5,572,099
Members
412,441
Latest member
kelethymos
Top