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.

Upload a small example showing a few 'what I have' 'what I want' and we'll provide some ideas.

Hi

Something similar to the attached would be suitable. Preferably I would like the postcode for each address to be in 1 column (perhaps column H) but right now that it's a neccessity.



Edit
The post code problem has been sorted. Not quite sure how i did it but all the postcodes jumped into 1 column O_o.

Still need blank cells to be removed so the address is only in columns ABCD instead of ABCDEFGH

Where does the address data come from?/Where is it generated? Maybe you can attack the problem of blank spaces before it gets to your worksheet. Can you use the concatenate function to help get the house number into the same cell with the street address?