In Progress

excel formula

Hi There,

I need an excel formula to delete words that are in CAPITALS and ignore sentence case and lowercase.

I have managed to extract the UPPERCASE words using this formula:

=RIGHT(B2,MATCH(0,--EXACT(UPPER(MID(B2,LEN(B2)-ROW(INDIRECT("1:"&LEN(B2))),1)),MID(B2,LEN(B2)-ROW(INDIRECT("1:"&LEN(B2))),1)),0)-1)

ctrl+shift+enter

But need to DELETE them.

eg:

The dog is WET

The Dog IS wet

THE Dog is WET

should be:

The dog is

The Dog wet

Dog is

Any help would be greatly appreciated!!

Skills: Excel

See more: excel formula wet, len excel, excel help formula, need help excel, len, excel formula, b2, words upper case, excel delete row, excel match formula, need formula, excel extract, excel delete, excel enter, ctrl, delete ignore, excel match, excel using formula, excel shift, excel formula using, yield formula excel, tiered pricing formula excel, paste formula excel, help excel, rank formula excel

About the Employer:
( 21 reviews ) Australia, Australia

Project ID: #1245736

Awarded to:

milledl

I have the formula!

$7 AUD / hour
(3 Reviews)
2.4

7 freelancers are bidding on average $6/hour for this job

vserv

Specialize in Excel work. Please see your messages. Thanks

$8 AUD / hour
(54 Reviews)
5.6
koolsidz

Excel Whiz here ;) Please see PMB for more details.

$8 AUD / hour
(85 Reviews)
5.6
viralsharma79

Sir, Check PM

$2 AUD / hour
(1 Review)
1.4
cinlyng

Hello I am ready to sort this for you Kindly check PMB for more details

$8 AUD / hour
(0 Reviews)
0.0
wmamun78

Sir, I am preparing for your problem solve.

$2 AUD / hour
(0 Reviews)
0.0
bsvrao7

Sir,i am ready to work on your project,please check PM

$6 AUD / hour
(0 Reviews)
0.0