Break cell value

[GUY08347]

Hi there,
i have a list of image dimentions layed out in a sheet from cells c2:c221
it looks like:

1140x223
1201x250
1000x600
1440x900
... and so... to c221

i want to break each one, with a macro, so that i will have:
in d1: 1140 in e1 223
in d2: 1201 in e2 250
.....
...

thank you,

 

[Claymationator]

Could you just copy all of the cells into column D, and then do Text to Columns with "x" as your delimiter?

 

[Claymationator]

If you need to leave the original data in column C, then you could use these formulae in columns D and E to get the result.

Excel Workbook
	C	D	E
1	1140x223	1140	223
2	1201x250	1201	250
3	1000x600	1000	600
4	1440x900	1440	900
Sheet1

Excel 2010

Cell Formulas
Range	Formula
D1	=LEFT(C1,FIND("x",C1)-1)
D2	=LEFT(C2,FIND("x",C2)-1)
D3	=LEFT(C3,FIND("x",C3)-1)
D4	=LEFT(C4,FIND("x",C4)-1)
E1	=RIGHT(C1,LEN(C1)-FIND("x",C1))
E2	=RIGHT(C2,LEN(C2)-FIND("x",C2))
E3	=RIGHT(C3,LEN(C3)-FIND("x",C3))
E4	=RIGHT(C4,LEN(C4)-FIND("x",C4))

Note that this will leave the results as text, so if you need numbers just add "+0" to the end of each formula to have the results shown as a number.

Hope that helps.

 

[Peter_SSs]

Could you just copy all of the cells into column D, and then do Text to Columns with "x" as your delimiter?

That would certainly work but there is no need to copy the data first - step 3 of the wizard allows you to specify where the results should go and you could just enter D2 there.

 

[Claymationator]

That would certainly work but there is no need to copy the data first - step 3 of the wizard allows you to specify where the results should go and you could just enter D2 there.

True, I was assuming that the original data format needed to remain entact.

 

[GUY08347]

GREAT!
it's exacly what i needed! THANK U very much.

 

[Peter_SSs]

True, I was assuming that the original data format needed to remain entact.

Using my suggestion, it *will* remain intact.