How to recognize that a cell contains a #?

[rsavarain]

Hi guys, How to recognize that a cell contains a #? Regards!! Raphael Savarain

[dilipandey]

Hi rsavarain,

You can use the search function as =SEARCH("#",a1) and if a1 has # in it it will produce a number.
By the way if a column have big lengthy number which is not adjusting in the column width, then that number will show as ####.

Regards,
DILIPandey

<click on below 'star' if this helps>