Recent content by paramnayak

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)