Formula help - Please

[dineshchaure26]

Hello:

In column A, there is a raw data. I need to separate the raw data in two columns B and C.

Column B shows expected and correct data. Column C doesn't work correctly and I need help fixing this. Expected result that is needed in column C is pasted in the last column.

RAW DATA	FORMAT 1	FORMAT 2	EXPECTED RESULT IN COLUMN C
FORMULA USED ->	LEFT(A3,FIND("-",A3)-1)	RIGHT(A3,FIND("-",A3)-1)
99-25	99	25	25
100-05+	100	05+	05
102-31	102	-31	31
101-25	101	-25	25
101-27	101	-27	27
99-04	99	04	04
107-15	107	-15	15
108-22	108	-22	22
109-00	109	-00	00

 

[jtakw]

Hi,

Looking at the formula you're using for Format 2, I assume your expected result is Always 2 digits, and looking at your expected results, you want to Keep leading zeros, if so:

Book3.xlsx
	A	B	C
1	RAW DATA	FORMAT 1	FORMAT 2
2	99-25	99	25
3	100-05+	100	05
4	102-31	102	31
5	101-25	101	25
6	101-27	101	27
7	99-04	99	04
8	107-15	107	15
9	108-22	108	22
10	109-00	109	00
Sheet986

Cell Formulas
Range	Formula
B2:B10	B2	=LEFT(A2,FIND("-",A2)-1)
C2:C10	C2	=MID(A2,FIND("-",A2)+1,2)