If is is all numbers.. try the below in Col B ,cell B1 and copy down which
will return the cells with special characters

In cell B1

=IF(ISNUMBER(A1),"",A1)

--
If this post helps click Yes
---------------
Jacob Skaria


"TGV" wrote:

Hi,

I am having datas in A Column in the below mentioned manner.

A
123'658
346*785
569}912
265879
792{1039
1015"1166
564897
1238@1293

Now I want a function that should check the cell for special characters.
Some of the cells does not consist the special characters, So I have to take
the data separately what are all the cells contains special characters. Is
it possible? If so please suggest me.

Awaiting for your reply.

Thanks in Advance!

TGV