• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Excel - imported data not working for vlookup because of funky format?

In the attached file, one vlookup works, and one doesn't. The non working one has the reference cell copied from a web page. Looks the same, but isn't. Why?
1 Solution

It seems like there are some funky characters in the bad example

I used this to test it.  Instead of a space (char(32)) it is spaces mixed with char(160)

Sub test()
    Dim s As String
    s = [B1].Value
    For i = 1 To Len(s)
        MsgBox "'" & Mid(s, i, 1) & "'" & vbCrLf & Asc(Mid(s, i, 1))
    Next i
End Sub
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now