mak345
asked on
Using "Proper" Function within VBA
I have a cell in Excel that contains a string.....Is there any function in VB that will update that cell making it Proper Text?
example:
Total liabilities
should be changed to:
Total Liabilities
Thanks
example:
Total liabilities
should be changed to:
Total Liabilities
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry it should be
=PROPER(A1) 'A1 being the cell to be formatted
dragontooth
=PROPER(A1) 'A1 being the cell to be formatted
dragontooth
ASKER
thank you
dragontooth