could you please provide the short cut keys of xl formulate?
On 9/22/2012 11:11 AM, zoher kheriwala wrote:
You can achieve this through (if) formula.
type the following farmula in the b1 cell.
=if(a1="nashik","nsk",if(a1="pune","pn"))
hope it will solve your problem.
zoher kheriwala taheri menswear mumbai. skype id zoher.kheriwala
----- Original Message ----- From: "Mukesh"
<mukeshbaviskar....@gmail.com>
To: <accessindia@accessindia.org.in>
Sent: Friday, September 21, 2012 9:59 PM
Subject: Re: [AI] Excel formula
Hello Ashutosh,
Thank you. It is working fine. Now I have one more query:
cell a1 cell b1
any name of district abbreviation of district
(for example: Nashik: nsk, Pune: pu, Latur: l, etc)
My question is:
When I type a name of any district in cell a1 the abbreviation of
that particular district should come in cell b1 automatically.
Suppose I type 'Nashik' in cell a1 the abbreviation of Nashik should
automatically come in cell b1 'nsk'. Please guide me at the earliest
because I have to complete my database within two/three days. Thank you.
Regards
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Aashutosh pandey" <cuteaashutos...@gmail.com>
Sent: Friday, September 21, 2012 2:59 PM
To: <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel formula
Sir you can use =concatinet() hopeit will work
On 9/20/12, Mukesh <mukeshbaviskar....@gmail.com> wrote:
Dear Friends,
I have created a database in excel. My query is:
Columns: a1 b1 c1 d1
Titles: districts vi/si m/F (Combination abbreviation of these
three cells
should come automatically)
Example: Nashik vi m nskmvi
How to do this with a formula? Please suggest me a formula at the
earliest.
Thank you.
Regards
Mukesh Baviskar
Mobile: 9403161157
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other
changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
--
Thanks with best regards
Aashutosh Pandey
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other
changes, please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in