I have 2 MID function formulas that I use to extract data on a specific cell string on an excel spreadsheet which work perfectly fine for me when used separately in different columns, but I would like to use these formulas together with an “OR” logic on the same column since my data could be either or, and will never have both conditions on a single cell, please assist

I have the following in columns A1=A00001,A2=A00002,A3=A00004,A4=A00005,A5=A00006. I would like to convert it to A00001-A00002 and A00004-A00006 in Excel. Please help

How to restrict user 2nd time entry in filled cell in google sheets

I am trying to understand the calculation of a quadratic regression in Excel in order to break it down step by step into individual calculation steps.The aim is that each step of the calculation is performed individually in a column. The calculation comes from an Excel forum from over 10 years ago.

As a test, I tried to find space using “=FIND(” “,D2)” for D2 cell written like “2017/9/1 0:02:01”, but I got an error like “#VALUE!” and I cannot fix it. I would appreciete it if someone can advice, thanks.

Assuming: Cell A1 = “Hi” and A2 = “Bye”

here is what my structured table looks like:

Question:

The use of INDIRECT when a range is specified (i.e. INDIRECT(“H2:H5”)) results in an array of values — in the case of my example, I get 4 values. What I would like to do is to create an array of values resulting from multiple ranges.

Hi Guys having a bit of trouble on this excel sheet. When I use evaluate, it goes to 1.14 and in the input data sheet there is data but when I evaluate it returns N/a . The maddening part is it works for 2.14,3.14,4.14 , etc. but just not 1.14 and the other sister value of 1.16 beside it`