Hi Friends,
Name: Bakul Patel
Tip of the week;
Convert name from "bakul" to "Bakul".
If you have a big list of names & you want to make it like this then this would
be helpful.
A B Result
1 bakul =PROPER(A1) Bakul
Cheers,
Bakul
--- On Fri, 6/19/09, Upendra Singh <upendrasinghsen...@gmail.com> wrote:
From: Upendra Singh <upendrasinghsen...@gmail.com>
Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP> <WEEK # 25> <Submit your TIP
here only> Options
To: excel-macros@googlegroups.com
Date: Friday, June 19, 2009, 8:09 AM
Hi Friends,
Name : Upendra Singh
TIP : Hide Data in Cell or Worksheet from praying Eyes
ð Select the range you want to hide.
ð Go To Format=>Number=>Custom
ð In the type Box, type three colon (;;;) and press enter.
ð The data where the above formatting is applied will be visible in formula
Bar only and not in Worksheet Cell.
Regards,
Upendra Singh
9910227325
-------------------------------------------------------------------------------------------------------------
There are 10 kinds of people: Those who understand binary and those who don’t.
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
