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
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
Last edited by Richmate; 12-15-2010 at 01:32 PM.
define special chatracters!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
any thing other tha a to z and 1 to 0
Rich
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)
Excellent
Thank you so much
Rich
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks