hi all,
i want to hide a part of text in excel cell.
for example , say i type ----abc xyz,
i dont't want xyz to be visible in the sheet.
how can this be done
thanks in advance
dear all,
I want a hyperlink in excel to a file which will open the file location and select the file but not open it.
After doing some searching on google I am able to achieve this using---------------- explorer.exe /select,"C:\Folder\subfolder\file.txt" .
But here I have to paste this on file...
dear all,
i want to find sum of the numbers that are coming before "*"
i.e 2*50+7*60+4*45.
here i need sum of 2,7,4.
what can be the formula.
thanks and rgds
dear all,
say i have written 4*96+3*94 in a cell A1. I want the value of this in another cell say B1 by using A1.
what formula can i use in B1 to get the result.
thanks and regards
Dear all,
I want to customise the size of excel window when i use restore down button so that whenever i use it , i get the set size.
How can this be done
dear all,
i have made selection of some non continuous rows in excel using f8 / shift f8 (or shift/control).
but when i am pasting it in word all rows in between are also getting pasted.
How can i paste my selection in word
dear all.
how can i use conditional formatting from different workbook in excel 2016.
I have tried using name range but i am getting this message
"You may not use references to otherwork books for conditional formatting criteria"
dear bobhhc,
thanks for the reply. Just want to know one more thing. If the original picture is deleted than will the picture remain in comment.
Thanks and regards
dear all,
I want to copy paste a part of excel in a comment.
I am doing this by copying the part of excel and pasting this in comment using clipboard.
But i am not getting the format of excel (for example: the border lines). As a result the copied part is messy.
Is there a way to copy the excel...
Dear all,
I have an "m x n" table containing numbers,
If I select a number from this table , I want the top of row and column of the number to be highlighted. How can we do this using conditional formatting.
dear narayan ,
i want the result to be displayed as 23 ft X 5 inches.
(custom formatting 00 " ft X" 000 "inches" is giving the result
23 ft X 005 inches)
dear all.
Is there any way by which if I type 12045 in a cell , the outcome is 12 ft X 45 inches.
Last three digits should come in inches and if it is 045 than the result displayed should be 45 inches.
Some other examples
12345 should be displayed as 12 ft X 345 inches
23045 should be...
dear all,
I want to count the unique values satisfying 2 critera.
eg
ref no date item
2 01-02-2016 abc
3 01-02-2016 xyz
7 02-02-2016 abc
2 04-03-2016 abc
2 04-03-2016 xyz
7 05-03-2016 abc
3 07-03-2016 xyz
here ref no. and date should be unique . so total...
hi all,
I want a set of blank cells to give this message "no data entered".
Using conditional formatting , i can colour the blank cells but i am not able to put "no data entered".
Is there any way by which i can achieve this.
thanks and rgds
hi ,
Is it possible to create pivot table from tables which are in 2 different files using microsoft query.
Also I am facing an issue in my system where i am not able to refresh the pivot table created using four tables in the same file (using query).
thanx and rgds
go to developer--visual basic--insert--module and paste this. (with "=spellnumber( )" you will get the desired result
'****************' Main Function *'****************
Public Function SpellNumber(ByVal MyNumber)
Dim Taka, Paisas, Temp
Dim DecimalPlakhe, Count
ReDim Plakhe(9)...
dear all ,
I want to replace only 0 with 2 in the below formula.
=ROUND($E$247*J250,0)
How can i use find and replace to achieve this
the final outcome should be---
=ROUND($E$247*J250,2)
thanx and rgds