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 :-)