## Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

To whom this may concern, I have a question in regards to my project which involves working out a secret formula in the determining the odds section to …

Hi I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews. I would like the …

I have data that looks like this (three columns: Date, IGN and AP): Date IGN AP 8/8/2019 Emxmari0 3560 8/11/2019 Emxmari0 3580 8/12/2019 Emxmari0 3580 …

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? By:

Hi, Hope you’re fine and healthy. I have a time sheet for my employees and the working days of each employees calculates based on projects that employee …

Hi, Would very much appreciate your assistance tackling the following conundrum: I have two separate sheets. In sheet 1: I have a column A for …

Hi! I’m hoping someone can help me with this formula. I am looking for a formula to use that take the words that are in separate cells …

I unable to convert the amount i in Ms Excel to lakh in decimal. e.g. 234567 convert to 2.34 By:

I am trying to figure out what formula I would use to track value changes to my Blank Permits. For example, I have an Export Permit # 05064578 with several …

I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data …

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor with in that cell I want to track …

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor with in that cell I want to track …

I am having trouble with a project I am doing with Excel. For my statistics class I have to show the maximum temperature of the 50 states in a 30 day period. I …

Is it possible to have multiple criteria in a LOOKUP formula? By: hands in

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

Hello, I need to formulate the following row A 0 0 0 1 2 3 4 5 Row B Period end Period end Period end Row c …

I want to room students for specific exams. I would like to input a formula or something to allow 24 cells to be populated with the same room number. Is this …

Hi, I want to write a Macro in excel then it can find whatever in C2 and replace it with C1 in the whole worksheet. Please could you advice what to write it …

Using Sumifs, pls calculate total Item received by each warehouse and the amount of item received by each ware house …

Round up the cell contains symbol with number Eg ↓9.849639 output should be ↓9.85 …

<!– /* Font Definitions */ @font-face {font-family:”Cambria Math”; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; …

if cell B1 have any text then cell e1 should get 1000 automatically and if b1 have any text and d1 also have any text in such case e1 should have 4000 …

I have 2 excel files that I want to merge. Each has 2 columns, one of which is dates and one of which is dollar amounts. Within each sheet, the dates are in …

I have a workbook with dates that calculate to percetages. When I enter a new date the percentages does not change. Do I need to enter a digit before date …

I have a workbook with dates that calculate to percetages. When I enter a new date the percentages does not change. Do I need to enter a digit before date …

How can I convert this 0001-01-01T10:00:00.000 to local time By:

Hi I want to allocate Stock available (Column K) qty as per Sales order – Line item combination (basis first come first serve basis). Sales …

I need a formula that will search a specific cell (E2) or all of column E for a “key” word and then if found, take the date in A2 and add 30 days …

I have an event spreadsheet created with several colums. One of the coumns is “Class” recorded as A or B or C thru W. Is there an automated …

Help!! I’m trying to split up an excel file that has 13865 lines into separate tabs. I want to break this into groups of 1387 lines and retain the …

Help with excel formula nested IF statement in simpe spreadsheet using Excel 2016 with Windows 10. Hi, I am trying to include a nested formula in a …

Hi, I am trying to include a nested formula in a spread sheet. the formula is =IF($G22=”S”,$E22-205,””,IF($G22=2,E22)) G22 is either S …

Is there a shortcut to move all remaining text right of the cursor into next cell to the right? By:

Dear sir, I have Quarry I Have Stock Item in Column A1 Cell Phone A2 Key Borad Key Borad Column B1 Amount Rs 10,000 Columns B2 Amount …

Hi I want to apply conditional formatting to entire column. Here is my requirement: I want to highlight a cell if it has a value (date to be specific) …

I am using Excel 2007 on a PC. I’m using the following formats to enter names in the same column: 1. Last name, First name – for males and …

Hi, I’m new to excel and I want so badly to learn it. Anyway, I’ve recently been tasked with attendance and coordinating plans for teams. I …

I am looking to understand the following. A friend of mine (can’t reach him for a while) created a formula that does this: When you COPY (CTRL+C) a URL …

I cannot work out what I am doing wrong. I want to return the highest value if any of the two values in two cells is above 155, otherwise return the lowest …