2 Red Dots trailing a String?

Question

Has anyone ever seen this before?

I couldn't get it to filter out so I copied and pasted the values from the table and it has 2 red dots at the end....

A bunch of the cells I have seem to have this around a certain grouping.

Can anyone tell me what it is?

Thanks

error.PNG

grazitti_sapna · Answer

@JordyMicheal , This might be some special character coming up in your data which is visible as red dots. You can try opening the file in notepad++ and check the format. If possible can you please share the file in which this data is coming may be I can do the analysis from my end.

ShankerV · Answer

Hi @JordyMicheal

Those 2 red dots are special characters

It is created when you press ALT + 7 in Excel

So I believe you are inputting the data's from Excel

Use the Data Cleansing tool to remove the special characters and proceed upon

Hope this resolves your issue.