Hey Prabhu,
try this formula
=IF(ISERROR(REPLACE(A1,FIND(ABC,A1),3,#)),A1,(REPLACE(A1,FIND(ABC,A1),3,#)))
On Thu, Jul 21, 2011 at 8:50 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
Can you help me to know the formula for find and replace.Examble i need to
find ABC in the A1
try this
=IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#)))
On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
In the attached sheet wherever we find *Opt. *(Opt dart and a space) is
replace with # and add with the previous cell
*Hey,
Please find the below mention link for Microsoft Excel 2077 VBA Macro
Programming 2009*
http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
*
Regards, Vikas Chauhan*
On Wed, Jul 13, 2011 at 3:46 PM, jmothilal gjmothi...@gmail.com wrote:
if any one have pdf file
Hey,
Find the below mention link and read it.
Advance Filter Intro. http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter01.html
On Wed, Apr 20, 2011 at 4:35 PM, rohit gupta gupta1.ro...@gmail.com wrote:
hiii,
kindly let me know what are the benifits
Dear Friends,
How to use Networkdays Formula in Access
--
One Team One Dream One Goal
Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_*ccess *without U
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
HI Expats,
Greeting for New Day !!!
I want to export data from mysql to .csv format. just want to click in
command button and data save to define location..
it's very urgent so pls help me !
--
One Team One Dream One Goal
Warm Regards,
*Vikas Chauhan*
Hi,
use single quote ' then type 16digit number
'12345678912345678
On Sat, Feb 26, 2011 at 1:31 PM, Ashish Khandelwal 4everash...@gmail.comwrote:
Hi friends,
When I enter a 16 digit number in a cell, the last digit become 0. How can
I enter a 16 or more digit number in a cell.
Thanks
Hi Puttu,
if you are using Excel 2007 then
use formal : - =IFERROR((IF(VLOOKUP(C12,Ukey,1,0),
YES, ),)
AND 2003 then
=ISERROR((IF(VLOOKUP(C12,Ukey,1,0),
YES, ),,(IF(VLOOKUP(C12,Ukey,1,0),
YES, ))
On Thu, Feb 24, 2011 at 6:13 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
I have
Hi Jitender,
it's done without using vba coding
just change CODE
On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar jk9779771...@gmail.comwrote:
On 21 February 2011 10:25, anil panchal anil.kan...@gmail.com wrote:
please send sample file.
On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh
Hi Sudhir,
please find the attachment and check it,
On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote:
Dear Frnd
I have list which have many repeated names
i want short it with formula
thanx
--
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before
please provide data in excel..
On Sat, Jan 15, 2011 at 6:25 PM, herman gold gold.her...@gmail.com wrote:
a1 has IN, b1 has date, and c1 has time
a2 has OUT, b2 has date, and c2 has time
On Jan 15, 12:49 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
You need to tell us
Hi,
Congratulations Ashish, and thnx for your great contribution,
On Mon, Jan 3, 2011 at 2:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Congratulations Ashish, Keep it up...
Thanks,
Noorain Ansari
On Sun, Jan 2, 2011 at 1:07 AM, Rajasekhar Praharaju
send ur file
On Tue, Dec 21, 2010 at 10:45 PM, SAJID MEMON sajidwi...@hotmail.comwrote:
Dear All,
I had made a project in excel and some macro made but i had protected with
password and forget the password.
How can i recover my VBA password.
please give me some tips to accomplish my
hi use sum if function
On Sun, Nov 14, 2010 at 12:55 PM, bhavya khanna bhavya...@gmail.com wrote:
Hi Everyone.
Can someone explain I have data in sheet 1 The columns Name and Production
. Now I want to fetch data in sheet 2 . I use vlookup on the basis of Name
and fetch the production .
can u give me example sheet??/
On Sat, Aug 21, 2010 at 4:15 PM, Kishan Reddy, K
kishanreddy.kethire...@gmail.com wrote:
Dear Jai,
Select the cells that you want to hide.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box,
yes
On Sat, Jul 31, 2010 at 7:24 PM, kamlesh jain kjain1...@gmail.com wrote:
Dear Members,
Is it possible to open a password protected excel file if password lost.
Thanks in advance.
--
Regards,
Kamlesh Jain
--
Hi,
Ctrl+T for new tab and change tab ctrl+1(for first tab),ctrl+2(second
tab)ctrl+3..and Ctrl+W for closed current TAb...
On Fri, Jul 9, 2010 at 5:42 PM, bruce goo...@johnsonclan.net wrote:
I have the need to work with IE8 and TABs. I have found out how to
open a new tab, but
Dear Friends,
how to auto generate .doc file using excel data..
in excel sheet cell A1 -- ID NUMBER and B1 -- DETAILS
For Example
* A1 B1*
*ID NUMBER* * DETAILS *
1 012345AMIT KUMAR
hi,
The default setting for each cell is for them to start locked. So, you first
need to highlight ALL cells in the sheet, right click, choose format, go to
the Protection tab and take the tick out of the Locked box.
Now no cells are locked.
Now you need to select the one cell you want locking.
POWERPNT
On Thu, Jun 24, 2010 at 10:21 AM, janet dickson janetdicks...@gmail.comwrote:
Hi Team
*Sorry for asking this in excel group.*
Does any one know the Shortcut for opening a MS Powerpoint using run box
(Winkey + R) ??
I can open several programs in run box (winkey + R) as shown
the actual data is in the cell i.e. for number as well as for
character data.
Please suggest.
~ Rajesh
On Jun 11, 9:49 pm, Vikas Chouhan vikask...@gmail.com wrote:
Chk this
On Fri, Jun 11, 2010 at 7:19 PM, Rajesh Bedse rajeshbe...@gmail.com
wrote:
hey Paul,
Plz let me know how can
Dear Frnd,
may be this formula helping u
*=IF(ABS(((MID(A5,3,1)*8+MID(A5,4,1)*7+MID(A5,5,1)*6+MID(A5,6,1)*5+MID(A5,7,1)*4+MID(A5,8,1)*3+MID(A5,9,1)*2)-97*2))=ABS((MID(A5,10,2))),Valid,Not
Valid)*
On Sat, Jun 19, 2010 at 4:14 PM, NOURREDINE BELHAJ
Dear Group Member(s),
I need some help with my query please it’s a urgent!!!
I have a data in excel sheet two columns name and count. I want if in column
name vikas and count 10 then I want automatically insert 10 time vikas
Hope some one helps me.
I have also attached example.xls
Dear Han,
please send example sheet.
On Thu, Jun 3, 2010 at 1:16 PM, Han microsoftexcelc...@gmail.com wrote:
Hi Everyone,
I need some help with this formula problem I'm working on, so if you
have any free time you can help me solve it would be great.
Tab #4 on the attached spreadsheet
send your file.
On Sat, May 22, 2010 at 7:19 PM, Alpesh Gajjar gajjars...@gmail.com wrote:
Dear All,
I have sheet which is password protected. I forget the password.
Please suggest me how i open this file and remove the password.
Its urgent, please help.
--
Alpesh
Muralidhar,,,
Just Chk attache file.
On Sat, May 22, 2010 at 7:59 PM, NRao Mynampati
ml.narasimha...@gmail.comwrote:
Hi deepak,
advance filter use for u.
On Sat, May 22, 2010 at 3:28 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi Murali
Dear All,
Viva for the Day!!!
i have more than 50 excel file in a 'D' Drive Folder, i want consolidate all
excel file in a one file using macro please help me it's a urgent.
1) all file header's format are same
2) data in sheet 1.
please help me
hi,
thanx
On Thu, May 13, 2010 at 12:03 PM, Rajesh Nair nairra...@gmail.com wrote:
Hi All,
Please find attached Excel formula book .
This may help.
Regards,
Rajesh. Nair
--
--
Some important links for
me also send pleasvikask...@gmail.com
On Thu, May 13, 2010 at 11:22 AM, Nani Ram 06n...@gmail.com wrote:
Hi Excel Masters,
Could any one have MS-Excel Bible by john walkenbach e-book.
if so could please send it to me at 06n...@gmail.com.
Thanks in advance,
Nani Ram
two way
1) put formula =COUNTIF($A42:$A$8,Bill)
2) Make Pivot table
On Tue, May 11, 2010 at 1:00 PM, nyberg75 nyber...@gmail.com wrote:
Hi
How can i sum/count the number of times a name has occured
Example:
John
Bill
Gordon
Bill
Bill
Sara
Bill
John
Result:
Bill = 4 times
hi how to use the command pls ex plane
On Tue, May 11, 2010 at 6:10 PM, vikas gupta vikas.63...@gmail.com wrote:
HI ANAND
YOU CAN USE RTRIM COMMAND
REGARDS
VIKAS GUPTA
9311334683
On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.com
wrote:
Please help out. I got
http://www.ebooknetworking.com/-c-21.html just chk this link
On Sat, May 8, 2010 at 4:36 AM, prabhakar thakur prabhakarthak...@gmail.com
wrote:
Kindly send book of dot net.
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
On Wed, May 5, 2010 at 6:39 PM, prabhakar thakur
hi anand how are you
AB
1 vikas kumar =right(A1,LEN(A1)-FIND( ,A1) RESULT IS KUMAR
On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Use the function RIGHT(Select the whole text in which the textor the
/downloads/folderprotect.zip
and then do the steps provided by you.
Harry
On May 3, 10:45 am, Vikas Chouhan vikask...@gmail.com wrote:
Hi,
Harpreet
*ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *
*how to use*
open notepad and paste this command *ren
aaa.{21EC2020
Hi,
Harpreet
*ren aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *
*how to use*
open notepad and paste this command *ren
aaa.{21EC2020-3AEA-1069-A2DD-08002B30309D} aaa *and save as key.bat file
name
after make key.bat file
make new folder in desktop and in folder put key.bat file and
Hi,
u used
Data--Import External Data-Import Data -Chouse excel file
On Thu, Apr 29, 2010 at 10:10 PM, Hitesh Dhare
hitesh.dh...@idea.adityabirla.com wrote:
Hi There,
I am looking for a Macro which copies data from different Excels's
specific sheet into new Excel by appending the
hi,
if u went count of identify unique dates for employee ..
put.. =COUNTIF(A:A,A1)
On Wed, Apr 28, 2010 at 12:34 AM, Chetan chetu...@gmail.com wrote:
Can anyone help me on this issue
On Apr 26, 5:13 am, Chetan chetu...@gmail.com wrote:
Hi Harmeet Singh,
Thanks for your reply, It
Dear All,
Please help me for excel condition formula's, pls send formula with example
...pls it's a urgent.
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell
Hi,
Dear Just Chk this formula
*=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789)),100)*
On Sun, Apr 25, 2010 at 7:46 PM, Ahmedhonest ahmedhon...@gmail.com wrote:
Dear Team,
Pleasure seeing and Tons of thanks serving the members with your valuable
suggestions and ideas.
My query is
Chk it,,
Multiplies all the components of the two arrays and then adds the products —
On Wed, Apr 21, 2010 at 10:10 AM, Jai jaihumtu...@gmail.com wrote:
Dear All, Can you tell me that what is the work of sum product.
--
Thanks For Mail.
--
hi,
dear u used www.pdfonile.com site convert pdf to word and after changes
convert word to pdf
On Sat, Apr 17, 2010 at 1:25 PM, Jai jaihumtu...@gmail.com wrote:
Dear All Groups Members
I Need In PDF Editor Can you Give me ?, This is very urgent for me.
--
Thanks For Mail.
--
http://www.nitropdf.com/free/hammer/index.htm
On Sat, Apr 17, 2010 at 1:25 PM, Jai jaihumtu...@gmail.com wrote:
Dear All Groups Members
I Need In PDF Editor Can you Give me ?, This is very urgent for me.
--
Thanks For Mail.
--
hijust chk
On Thu, Apr 15, 2010 at 12:51 AM, MD18358 michael.e.dray...@citi.comwrote:
Hi All:
I don't want the number of Permutations I want to see the
permutations to a calculated sum.
For example: How many different ways can I get 20 by looking at the
number 1 through 19.
My
Hi
Wht type Help u req in access (Query,Form.)
On Mon, Apr 12, 2010 at 11:47 PM, anju anjulav...@gmail.com wrote:
Can we use wildcards with instr function.If yes how ?
I also need help in MS Acsess ? Can u pls guide me to the right way
--
Chk this link http://obp.math.vu.nl/edu/project-obp/VBA-intro.pdf
On Tue, Apr 13, 2010 at 2:53 PM, Venkatesan c venkat1@gmail.com wrote:
Thank u Dilip
Can i have any pdf with u
On Tue, Apr 13, 2010 at 2:49 PM, Dilip Pandey dilipan...@gmail.comwrote:
Hi Venkatesan,
Up to Excel
Hiii,
Dear Run this file
On Thu, Apr 8, 2010 at 6:14 PM, Jai jaihumtu...@gmail.com wrote:
Dear All,
Can you Give me VBA Passward Cracker,
--
Thanks For Mail.
--
--
Some important links for excel users:
Hi
Open http://vikask008.hpage.com/ and click free games download link
On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram 06n...@gmail.com wrote:
Hi All,
Does anybody have games in excel sheet, if so please send me.
Thanks,
Naniram
--
hi,,
dear i have one problem. how to copy and paste formula because this
is array formula function..
On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Anil,
Attached file is solved as per your requirements. Formula is also there.
Let me know if you have
Hi, Hemant
Chk This link
*http://ineedfile.com/access-2007-bible-free-download*
On Wed, Apr 7, 2010 at 6:09 PM, Hemant K hemantkora...@gmail.com wrote:
Hi Group,
Any one have this book pls provide it.
--
Regards
Hemant Koranne
--
Hi,
Go format as table,
On Wed, Apr 7, 2010 at 6:23 PM, Jai jaihumtu...@gmail.com wrote:
Dear All Members.
How can put the filter 2 times in One Excel file .
--
Thanks For Mail.
--
--
Some important
HI,
Right Click .txt file and open with excel just try it
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh mahender.bi...@gmail.com wrote:
Dear All,
Need ur advise...
I got around 20 text files in a day,which had 13 to 15 columns separated by
| this sign. each file contains around 15 lacs or
Dear All,
Please help me in *access* please provide access queries and how to put
queries,,,
*and how to vlookup,concatenate in access *
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_ccess
Dear All,
Please help me in *access* please provide access queries and how to put
queries,,,
*and how to vlookup,concatenate in access *
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell
*how to put formula,lookup in access*
On Sat, Mar 27, 2010 at 4:29 PM, Deepak Rai daksh1...@gmail.com wrote:
Hi Vikash,
Want help you want on Access ?
Regards,
Deepak
On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan vikask...@gmail.comwrote:
hi
Dear all please help in access urgent
Hi Dear all,
*Please help in access* it a urgent
On Fri, Mar 19, 2010 at 10:45 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:
Dear Masters,
File attached for your kind consideration and support.Please let me know
whether the objective from Sl No.6 onwards is possible to achieve or not.
hi
Dear pls open this link.
*http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/
*
On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram 06n...@gmail.com wrote:
Hi Members,
i have huge data with hyperlinks.
Is there any shortcut key or formula to remove all
Hi,
if there is ten excel file in a folder, how to convert these files's into
one .txt file
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_ccess without U
Life is Very beautiful !!!
¨`•.•´¨) Always
in excel sheet (password protect) open and press alt+f11 and paste code
.
good luck
On Mon, Mar 15, 2010 at 10:21 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
Hi Gurus,
How to use please tell me explain
Thanks in Advance
Nandkumar
On Mon, Mar 15, 2010 at
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_ccess without U
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.
--
Dear All,
Pls send V.B.A e-book ..or url
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
We can't Spell S_ccess without U
Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨)
Dear All,
(i am using 2003 office)
if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one column
(a1:a10) how i get the sum doller, rupees or more currency in different
column
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :-
Dear All,
(i am using 2003 office)
if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one
column (a1:a10) how i get the sum doller, rupees or more currency in
different column
--
One Team One Dream One Goal
Warm Regards,
Vikas Chauhan
E-Mail :-
2003
On Wed, Mar 3, 2010 at 7:06 PM, ankur ankurpande...@gmail.com wrote:
which version of excel you are using?
On 03/03/2010, Chieu Ang chieuang@countryfoods.com.sg wrote:
Dear all,
Anyone can help: How to unprotect the sheet( that has password)?
Thanks
Chieu
63 matches
Mail list logo