Check to see if a string is all in uppercase?

**pablowilks** · 10-11-2012, 02:22 PM

lets say i have a column comprised of things like the following

CHOCOLATE
CHOCOLATE-EGG
chocolate egg
easter-egg

I want to loop through each cell and check to see if the string in the cell is in uppercase (if entire string is in uppercase then do..... something)

the fact that some strings have none alphabet characters, does that make this more complicated?

thanks in advance.

**dilipandey** · 10-11-2012, 02:36 PM

Hi Pablowilks,

With you data in column A, try using below formula:

Formula:

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Andy L Gibson** · 10-11-2012, 02:52 PM

This might work:

Please Login or Register  to view this content.

Regards

Andy L Gibson

**pablowilks** · 10-11-2012, 03:38 PM

thank you Andy and Dilipendey. Much appreciated.

**dilipandey** · 10-12-2012, 05:52 AM

You are welcome pablowilks... cheers

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Check to see if a string is all in uppercase?

LinkBack

Thread Tools

Rate This Thread

Display

Check to see if a string is all in uppercase?

Re: Check to see if a string is all in uppercase?

Re: Check to see if a string is all in uppercase?

Re: Check to see if a string is all in uppercase?

Re: Check to see if a string is all in uppercase?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions