Special characters

**Richmate** · 12-15-2010, 10:10 AM

Is there a way I can get excel identify cell which contain special characters.

For example abcd()ef (nedds to be identified)
abcdef doesnt.

Thanks in advance

Rich

**martindwilson** · 12-15-2010, 10:18 AM

define special chatracters!

**Richmate** · 12-15-2010, 10:23 AM

any thing other tha a to z and 1 to 0

Rich

**martindwilson** · 12-15-2010, 11:21 AM

see attached use the list in col h as your reference, note this is not a complete list of characters some have been left out on purpose (eg char 32 ,space) and some modified (wild cards or they don't look up properly)