Defining a format oneself is a kind of commonly used skill in Excel, small today in needing teacher and everybody learn Excel together define a format oneself.
What say to everybody above all is, open a method to have two kinds from what define a format, one kind is pitch on unit right key clicks format of setting unit division after case; Additionally one kind is <Ctrl+1> of use shortcut key.
01, batch adds prefix
Requirement: Company name is added in front of every branch. Should input sectional name to show company name only + sectional name. Following plan institute show:
Define format code oneself: Indication prepositive content @
Explanation: @ expresses to want the content of the input in unit case.
02, fast input whether
Requirement: Should input 1 when indication " is
