Get instant live Excel expert help with Text Functions

how do I copy and paste without transferring the hyperlink attached? I need just the text.

Hi I've been tasked with finding out how many we've sold for every line we hold. They're currently listed as individual transactions and spreadsheet contains 6000 lines. Column A contains the name of the stock part and column F the quantity that's been sold. The spreadsheet has been sorted so at least column A is listed with all item 1 transactions, item 2 etc. I think I need a formula that compares the text in one cell with the in the following cell and, if it matches, count it the values that appear in Column F for each line I could be wrong ... I'm terrible at these! Any help gratefully received

Hey there! Disclaimer: I'm using Google sheets. I am hoping to find a formula that can give be the percent of cells in a column that have the text "Completed". Any help is greatly appreciated!

how would the formula look if possible, the cell checks 3 different columns each in different tables on different sheets, if the value is=< todays date in the cell, then it checks same row different column for certain value if its the value specified then it checks other cell same row if its blank then it takes text from another cell same row. so = cell 4 if cell 1=today and cell 2=value and cell 3=empty. then it checks entire table each row is separated and it does this for 3 sheets. obviously then when the cell thats blank has data entered it will be removed.

Hello, I need help allowing a function to ignore words in a cell and multiple the number and ignore the text in the same cell.

How to count number of rows that contain a cell that ends with specific text? all specific text have a length of 2 there are more than 10 specific texts that needs to be counted (LL, LA, FT, etc) the range is of 130 rows x 50 columns

I need help with a match and index formula that contains both numbers and text

I need help with an =whatif formula to subtract if a number but show text if text.

i have a couple of qustions regarding a servay am analaysing , i have a scale of numbers from 1-10 how much would you reccomend this , i wana change the numbers to text

time code calculator formula minor errors =TEXT(LEFT(D3,8)+LEFT(C3,8)+(RIGHT(C3,2)>RIGHT(D3,2))/86400,"hh:mm:ss")&TEXT(MOD(RIGHT(D3,2)+RIGHT(C3,2),25),"\:00")