Move information over

Hi All

I've been using this forum for a while now but never needed to post as there seemed to be an answer for everything somewhere.

However, I have a bit of a problem.

Being a rather unexperienced excel user i'm baffled by Macros and equations except for pretty much the basics. But i am willing to learn.

I have a list of addresses on a workbook which are separated into 7 columns for each line of the address. However many on the address only use 3 or 4 of these columns but leave blank cells inbetween. I therefore need some sort of work-around to move data over to the left into these empty cells.

I also need any numbers on their own (generally the building number) to be added to the begining of the next column (the street or building name). Ideally i want to be able to get the address to only fill 4 rows as i need to import the sheet into my office database. But Only a certain number of characters are able to fit each row so merging some columns isn't really an option.

I could do this all by hand but with over 5,000 addresses at the moment with 100's more coming through each day i want to be able to quickly format and add to a master sheet to work from.

(the rest of the sheet is full of equations and other information searching here there and everywhere to find duplicates are various varieties which i can then delete)

Any tips or advice would be most welcome and I apologize for any spelling or grammar errors, its friday and nearly home time so i'm rushing slightly.