SOLVED

# Minimum and Maximum Difficulty

Occasional Contributor

# Minimum and Maximum Difficulty

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 (Occasional Contributor)
Solution

# Re: Minimum and Maximum Difficulty

use text to column with separation (-)

# Re: Minimum and Maximum Difficulty

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)

# Re: Minimum and Maximum Difficulty

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