Boss wants a report of top 100 customers, thankfully you
have the data, but the customer names are all in lower cases.
Fear not, you can
Proper Case cell contents with proper() formula.
Example: Use proper("pointy haired dilbert") to
get Pointy Haired Dilbert
Also try lower() and upper() as well to change excel cell
value to lower and UPPER case
For more tips & Tricks CLICK HERE
No comments:
Post a Comment