Search results

done

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...

IT IS A TEXT STRING

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

i want the value 666 in B1

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

hi all, I want to format a cell in such a way that if i type 45 M in the cell , the outcome should be 45 kg / M

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...

thanks david and bosco. This solves my purpose

dear naresh , thanks for your solution. But is it possible to get the result in one formula.

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

yes its working. sorry , my mistake

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 luke and narayan, problem is that it also replaces 0 of J250 and becomes J252. Is there a way so that only 0 is replaced by 2

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