Need specific work on Proper

[sksanjeev786]

Hi Team,

I have multiple statements in Upper case

CAPITAL ONE VENTURE X CARD ALLOWS YOU TO EARN 10X MILES ON RENTAL CARS BOOKED THROUGH CAPITAL ONE TRAVEL

so I have used =lower function

capital one venture x card allows you to earn 10x miles on rental cars booked through capital one travel

But I need Capital One in proper formate.

Can anyone help me with this

Regards,
Sanjeev

 

[Joe4]

There is also the "Proper" function, which capitalizes the first letter in every word.
However, you only want the first letter capitalized in certain words.
How it to Excel identify which words you would like capitalized?
Do you have a list of them somewhere?
Or is "Capital One" the only one?

 

[Joe4]

If "Capital One" is the only one you need replaced, you could use a formula like this:

=SUBSTITUTE(LOWER(A1),"capital one","Capital One")

for an entry in cell A1.

 

[sksanjeev786]

If "Capital One" is the only one you need replaced, you could use a formula like this:

=SUBSTITUTE(LOWER(A1),"capital one","Capital One")

for an entry in cell A1.

perfect!!! i just flip flop the word under Substitute functions

Thanks you so much for your help!!!

 

[Joe4]

You are welcome.
Glad I was able to help!