left-right-or ?

[abuchan]

I have a set of data in an Excel 2007 spreadsheet and want to move it to Sheet2. I move all that I need except for one column which needs some work done to it and I keep receiving errors.

Sheet1 Column 12 is comprised of six digits, space, six digits, space, and four more digits. What I need is the first twelve (12) digits, less the space, moved to column1 on Sheet2.

The code I am attaching does the following:
The year 2009 to Sheet2 Column2
Column6 + Column7 to Sheet2 Column3
Column8 + Column9 to Sheet2 Column4
Column6 + Column7 + Column8 + Column9 to Sheet2 Column5.

Many thanks.

Please Login or Register  to view this content.

I think I should be using something like the attached, but can't make it work, especially when I try to add the Mid function.

Please Login or Register  to view this content.

[Paul]

Hi Abuchan, is this what you're after?

Please Login or Register  to view this content.

[abuchan]

This is perfect. I am embarrased to say how long I have been pounding my head against the wall.

Thank you very much.