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"