Hi,

I have got some data from my client (in CSV format) and one of the columns
has a small square at the end. Also, many of the cells in that column
contain extra lines in them (just like Alt+Enter).

I used Trim function on this column but neither the square nor the extra
lines are getting removed.

I tried Text to columns with fixed width and NO break line thinking that
this might remove the lines or extra lines but it didnt.

In Text to columns with Delimiter selected as TAB it worked (It seemed so).
Just wanted to know what this small square is. Is it equivalent to TAB?
And is the method of text to columns with delimiter being tab a SAFE way to
clean data of above mentioned type?

Thanks a lot,
Hari
India