Moving Data in Cells

[Cal_Ife]

Hope this is the right place to ask this. I have used excel for years but never in any depth.

I work on excel spreadsheets which have peoples names and addresses that has to be in a certain format in order to export it into a database. For example column A is Mr, B is First Name, C is Surname, D is date of birth, E is house name or number, F is Street Name, G is Town, H is County and I is Postcode.

The problem is clients send these spreadsheets in often with the data in the wrong columns or the whole address in one column and we have to spend a great deal of time copying the data into the right columns. We had a 700 people one the other day that took one person a whole day to re do.

Is there a quicker way to sort this out rather than just cut and paste into the right columns?

Thanks for any help :-)

[hectop]

If they are in the wrong order, but in separate columns you can have a generic VBA macro in which you specify the columns sequence that they should be put into.
The attached sheet has a sample. You can have the columns in any order on Sheet1 and the macro will put them into the order specified in Sheet1 Row1 into Sheet2.
ReorderCols.xlsm

If the data is combined in a cell, it can be parsed out, but it takes custom code each time since you don't know the order, or how the data will be separated.

[Cal_Ife]

Thank you I've had a look at your info, very helpful