Dec 02 2020 08:22 PM
Hello,
I have been struggling to solve a formula for this assignment. I have a number in ranges in one cell, I need to somehow split the cell numbers into two different columns. The first number in the cell is the minimum, and the second number in the cell is the maximum. I have attached an image for reference. For example, in M8, I need to somehow format the 8700 minimum (small number) into N8 8900 Maximum (large number) into O8. I need to do this for each row in Column M that has the number ranges in each cell. Column N is for minimum number (small number) and Column O is for maximum number (large number). Can you please help me create a formula for Columns N and O in order to fulfill this assignment without taking years to complete manually? Thank you!
Dec 02 2020 11:17 PM
SolutionDec 02 2020 11:55 PM
there is a separation which is ( - ) in almost all the rows, except the second and third rows.
Would please follow the pattern and use (-) separation then, you can use this formula assuming that your data on A1:
=LEFT(A1,FIND("-",A1)-1)
Dec 03 2020 01:21 AM
Dec 02 2020 11:17 PM
Solution