Change a word in to Title Case in Excel Cell using Macro

Q : Does anyone have a Macro to change the Title case of every word in an excel cell?

A: enter the following formula:


Copy down to the last row and then select all of column B and copy it with

Click on cell A1 and then right click on Cell A1 and select PASTE SPECIAL,
click the VALUES check box and click OK to replace all the original values
with there proper name format values. Delete column B when done.


About R.K. Depiya
Am working in a KPO company.. Am doing my BCA in correspondence

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: