Capital each word excluding “and” in the post code column all letters in upper case

**wykoems** · 12-24-2018, 12:58 PM

What I would like to achieve is capitalise to each word, but exclude the “and” word and in the post code column all the letters in upper case. I got the code from the net it is not doing what I want
As per sample: Mr and Mrs, not, Mr And Mrs
Post code: RE11 1WP, not, Re11 1Wp

**Richard Buttrey** · 12-24-2018, 01:14 PM

For columnd B:D a formula like

Formula:

Please Login or Register  to view this content.

or even change and to & with

Formula:

Please Login or Register  to view this content.

and for column L

Formula:

Please Login or Register  to view this content.

**wykoems** · 12-25-2018, 09:07 AM

This is the code I used to make capital each word, but I want to exclude “and” and in column “L” all upper case. So I would appreciate if someone can modify this code to exclude “and” also upper case in column L.
Thank you all and merry Christmas and Happy New Year

Please Login or Register  to view this content.

Capital each word excluding “and” in the post code column all letters in upper case

LinkBack

Thread Tools

Rate This Thread

Display

Capital each word excluding “and” in the post code column all letters in upper case

Re: Capital each word excluding “and” in the post code column all letters in upper case

Re: Capital each word excluding “and” in the post code column all letters in upper case

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Not differentiating between capital letters and lower case letters

[SOLVED] Converting capital letters to lower case in all but the first word in a string in a cell

Add characters between lower case and upper case letters

[SOLVED] Mass changing upper case to lower case letters

Change lower case letters to upper case

making lower case letters capital

Can I change upper case letters to down case automatically?

Bookmarks

Bookmarks

Posting Permissions