change 2#s in one cell to two different cells

[elbicho]

I imported a bunch of data that has some of the numbers listed as this 50-55
what is the forumla to change it some both numbers are in different cells.

 

[lplates]

You could try something like this -
In A1 your two values:
50-55
In B1:
=VALUE(LEFT(A1,FIND("-",A1)-1))
And in C1:
=VALUE(RIGHT(A1,LEN(A1)-FIND("-",A1)))

 

[elbicho]

thank you

 

[Jared_8878]

I know you asked for a formula, but just as an alternative - you could go into Data, text to columns, and select you delimiter as the dash.

 

[elbicho]

what if the data is imported like this 10/20 50% in the same cell. I just want the 10 and 20 in different cells.

 

[Peter_SSs]

what if the data is imported like this 10/20 50% in the same cell. I just want the 10 and 20 in different cells.

Is this what you mean?

Excel Workbook
	A	B	C
1	10/20 50%	10	20
Extract Nums

If they were always 2 digit numbers maybe
=LEFT(A1,2)+0
=MID(A1,4,2)+0

 

[elbicho]

yea that works.

Thank You