CODEWITHSUNDEEP
sql-serverexcel
José Gabriel Almendares
José Gabriel Almendares

Reputation: 375

Weird symbol in my excel data

I've the following problem, I have an Excel with three rows, I've copied the thrid row of these in the seventh column (as you can see in the first image) to do a query in SQL Server, apparently the data is clean (as you can see the second image) but when I copy this query in another text editor (W3Schools in this case, third image) this shows an weird symbol ("hidden" in the Excel and SQL Server editor) than I cannot delete with any SQL function, always it launches an erro; I want to quit this symbol and left my data clean. Thank you so much

enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 772

Answers (2)

José Gabriel Almendares
José Gabriel Almendares

Reputation: 375

Thank you to all, issue solved!! I just've replaced that character by a white space with a function.

Upvotes: 0

TotsieMae
TotsieMae

Reputation: 835

I've had something similar happen to me, and while this solution may not work for you, it's worth a shot.

Go to the cell holding the value of 4013802 and click into it. Press Home to get to the very far left of the cell. Now press Shift + right arrow once, then Ctrl + C to copy. It may look like it didn't grab anything, but trust that it did.

Now press Ctrl + H to open the Find and Replace dialog window. In the Find what: field, press Ctrl + V; leave the Replace with: field blank. Now click Replace All and see if it returns anything.

If Excel says it made replacements, try using your Excel data again and see if you get the weird character again. If Excel says it cannot find any data to replace, you may be dealing with something different.

That being said, it's definitely an unidentified character in the character set being used by Excel and SS.

Upvotes: 1

Related Questions