Changing first letter to caps, letters after "-" and "/", and rest to small letter.

Hi all,

I'm currently working for a company as a data entry admin. I'm asked to copy and paste some details from websites provided by the company and some websites have the addresses of the company in all caps.

My boss has asked me to change all these caps such that the first letter is caps, letters after "/" and "-" to caps, and the rest to small letters. He said that it would be very troublesome for him to do it himself 1 by 1, retyping them.

Obviously he don't know much about Excel. I did some research online and found this code.

Please Login or Register  to view this content.

This code successfully changes the first letter of each word to caps and the remaining letters to small letters, but I'm suffering from one problem.

Take for example I have an address that is

108-A SERANGOON ROAD.

This code changes it to

108-a Serangoon Road

My boss know nuts about excel, and I know nuts about these codes as I specialise in Java programming, so I'd like to seek your professional help in coding this code such that it will change letters that appear after "-" and "/" to caps as well.

I hope that's not too much to ask.

Try to use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Awesome. thanks for your reply. I've give the code a try very soon.

try

Please Login or Register  to view this content.

hi antoka05,

ur code only changes a certain number of fuse then there is error
is there anyway to allow more fuse to be changed at a time ?

Regards

hi jindo,

what happens if within one fuse there is both - and / , cuz it only changes the one that appears after the first sign

Regards

Add one line

Please Login or Register  to view this content.