Hi All
I know it's possible to change the case of text in a cell in Excel
using Lower, Upper and Proper, but is there a function that tells me
the current case of the text?
A user has a spreadsheet of catalogue items, some in proper case and
some in upper. He wants to seperate those in upper case into a separate
sheet but I can't think of an easy way of doing it.
Can anyone help?
Colin
--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile:
http://www.excelforum.com/member.php...o&userid=10472
View this thread:
http://www.excelforum.com/showthread...hreadid=477485