macro to move a field

I need to move the contents of a few thousand fields down 1 row and left 1 column. Then go down 1 and right 1 to get the next field to move.

I'm new to macros, but they don't seem to record the arrow keys. And/or I'm mis-using the relative/absolute reference thing.
I can also cut and paste (still extremely tedious) but I can't remember or find how to change a formulat to its result (I will need eventually to delete the cell that the "new" cell refers to.)

help? it's gonna be along night if I can't find a short cut.

Not to complicate things, but I'd also like to separate the street number from the street name which are now in a single field. Is there a shortcut or macro to find the "streetname" and have it and the rest of that cell move to a new cell?

A1 123 Main Street

desired result
A1 123
B1 Main Street

I have a list of all the street names that appear in my worksheet so I can use "find" to locate them, but I don't know the fastest way to complete the process.

Have:
A1 blank B1 Smith John
A2 blank B2 123 Main Street
A3 blank B3 Thomas Amy
A4 blank B4 678 East Avenue

Desired:
A1 blank B1 blank
A2 Smith John B2 123 Main Street
A3 blank B3 blank
A4 Thomas Amy B4 678 East Avenue

And ultimately:
A1 Smith John B1 123 C1 Main Street
A2 Thomas Amy B2 678 C2 East Avenue

I don't know what LEN etc mean, but that works and I am deeply grateful. I will be able to apply those formulas to the whole shebang.
Now my first question:

Have:
A1 blank B1 Smith John
A2 blank B2 123 Main Street
A3 blank B3 Thomas Amy
A4 blank B4 678 East Avenue

Desired:
A1 blank B1 blank
A2 Smith John B2 123 Main Street (moved contents of B1 to A2)
A3 blank B3 blank
A4 Thomas Amy B4 678 East Avenue (moved contents of B3 to A4)
Then I will need to delete all the blank rows

I bow to your font of wisdom, you solved the whole thing for me.
thank you thank you thank you.