SOLVED

Minimum and Maximum Difficulty

Copper Contributor

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!

4 Replies
best response confirmed by anniehoang (Copper Contributor)
Solution
use text to column with separation (-)

@anniehoang 

 

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)

please share file and please fill required result in first row for sample.

@devyadav2008 This worked! Thank you!

1 best response

Accepted Solutions
best response confirmed by anniehoang (Copper Contributor)
Solution
use text to column with separation (-)

View solution in original post