Hi guys,
I can't figure of a way to change the contents of my cells to Non-capitals text.
i.e
HELLO
BLUE
TELEPHONE
to
Helo
Blue
Telephone
is this possible?
Hi guys,
I can't figure of a way to change the contents of my cells to Non-capitals text.
i.e
HELLO
BLUE
TELEPHONE
to
Helo
Blue
Telephone
is this possible?
If your data in in column A, then in B1
=PROPER(A1) copy down
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Say data in Col A. Enter this in B1 and drag down
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Gosh, that was quick and solved my problem
No problem - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks