i have done basic C /matlab but thats about it

ok here goes i have 2 problems i

**HOPE**to solve

situation: 2 cols of data (54k long ><" ) col

**A**&

**B**

aim: copy data from col

**B**to col

**A, only if**the cell in col

**A**is

**blank**

PSEUDO CODE:

//

PSEUDO CODE:

*I KNOW LOL, THANKS FOR STARTING AT 1 NOT 0*

VAR X =1

VAR X =1

// check cell AX is empty, else copy from cell BX

**if sheet.cell.A(X) == isblank();**

sheet.cell.A(X) = sheet.cell.B(X)

sheet.cell.A(X) = sheet.cell.B(X)

//check for last row

**if**

**sheet.cell.A(X) == isblank() &**

**sheet.cell.B(X) == isblank();**

**exit**

// increase X

**X++**

//loop?

2nd situation: i have data is

**MM/DD/YYYY**, I want to convert them to

**YYYYMMDD**

i really do not have any idea on this, i am thinking in terms of reading each digit putting them in some LONG CHAR

or individual "BOXES" and reading them backwards

is it possible?

cheers

thanks so much.