Sometimes, you might need to create a desktop shortcut to Onedrive documents. Below is a method for Excel documents which can be used for any MS Office document.
First, you would need to find the path of Excel.exe on your computer. (more…)
Below is a proposed solution for the Challenge 66 - Find the Position of Word
Put the following formula and drag down. Let's assume the word "and" in cell D2 -
=LEN(REPLACE(A2,SEARCH(" "&$D$2," "&A2),LEN(A2),""))-LEN(SUBSTITUTE(
REPLACE(A2,SEARCH(" "&$D$2," "&A2),LEN(A2),"")," ",""))+1
You may download the solution workbook - Solution - Challenge 66 - Find the Position of Word
Suppose you have been given a word say "and" and you need to find which word position is this
You need to write a formula which finds the word position for the word "and"
Below is the test data.
Mr. and Mrs John Doe
The Reverend John Doe and Mrs. Jane Doe
Myranda and Lynda
You can also download an Excel to work on this problem - Challenge 66 - Find the Position of Word
The solution to this challenge will be published after a month i.e. on 14-Nov-17.
If you want to convert a, b, c....z to 1, 2,3....26, the you can use following type of formula -
Try dragging and dropping a picture in a worksheet - What happens. You will notice a plug sign which means that a picture will be added. But when you release the cursor to drop the picture in Excel sheet nothing happens.
Reason - Excel doesn't support dragging and dropping the picture in a worksheet.
Now, what to do. If you are dealing with too many pictures, it is cumbersome to use Insert > Picture command.
Fortunately, there is a work around in place. Microsoft Word supports dragging and dropping of pictures. Also good thing is that, you can select all your pictures in one go and drop in Word document.
Now, you can either drag and drop the pictures from the Word document in Excel sheet or you can cut/copy and paste from Word to Excel sheet.
Side Note - OpenOffice / Libre Office supports drag and drop to their respective spreadsheet programs. (Note, but you can not drag or copy and paste pictures into Excel from Open Office / Libre Office spreadhseets like you can drag or copy / paste from Word)
Last Updated - 29-Sep-15
Arrival of Windows 10 is something which everybody waited for and users had been loving it. But few users have been experiencing problems with MS Office and particularly with Excel post upgrade to Windows 10. Since, Excel is one of the most important productivity tools which all of us use every day, these problems are impacting productivity as well as delivery to customer. While MS Office on a fresh installation of Windows 10 is working great but for users who upgraded to Windows 10, some of them are feeling unlucky.
Many times when working in the Excel following errors may be encountered -
> We couldn't free up space on the Clipboard. Another program might be using it right now
> The clipboard cannot be emptied. Another program might be using the clipboard
--- The worksheet related to this problem can be found at Longest Word ---
Suppose you have a list of words in A1 to A10. The challenge before you is to write a formula (preferably non-array) to find the longest word in the list.
In case of ties, pick up the first longest word.
The response can be posted in the comments section of this post.
The best way to do this would be through utilities. The best one which I found out and is free is following -
Another way is to copy Word tables one by one (or in one go if layout permits) into Excel -