“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Want to embed .pdf file in excel. When I select insert object adobe files are not an option only word documents.

Solved by D. D. in 26 mins

This is the formula you provided to extract the last word form a text string to another cell: =MID(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(A1))
The problem is that I need it to extract (remove) the word form the end of the text string and insert it into the new cell. This is not happening with this formula.

Solved by T. F. in 28 mins

Use the SUBTOTAL function to complete the following: In cell H7, insert a formula that counts the number of cells in the Category field that are not empty. In cell H8, insert a formula that sums the cells in the Units field. In cell H9, insert a formula that sums the cells in the Subtotal field. In cell H10, insert a formula that averages the cells in the Retail_Price field.

Solved by F. F. in 30 mins

I need a formula that if column A is a certain word It will make the value in column b negative and if the word in column a is another word the value in column b will be positive

Solved by G. W. in 15 mins

I am using a 2017 iMac and working with pdfs and excel. I wish to insert pdfs as objects into a Microsoft excel tracker. I go to insert on the excel ribbon and then go to object. The drop down menu only allows the insert of word and not pdf. Is there a work around for iMac?

Solved by C. E. in 17 mins