Hi !If cell B2 contains the range like '50-100' so the beginner level formula for cell
- B3 is
=LEFT(B$2,SEARCH("-",B$2)-1)
- B4 is
=RIGHT(B$2,LEN(B$2)-SEARCH("-",B$2))
…
=VALUE(LEFT(B$2,SEARCH("-",B$2)-1))
=--LEFT(B$2,SEARCH("-",B$2)-1)
Sorry for the late response but many thanks for the input and it worked!Anything extracted using the text functions LEFT, RIGHT or MID will be returned as a text string. The function VALUE will coerce the text to a number, as will double negation.
=VALUE(LEFT(B$2,SEARCH("-",B$2)-1))
=--LEFT(B$2,SEARCH("-",B$2)-1)