Hello, I have another Excel dilema.

Actually this is my brothers problem, not mine, but I thought I would ask you lovely helpful people. (And give you something to do Dafoot :hihi:)
He has a database, but all the data is in one column. So for e.g

Mr A.J. Smith 123 Fallover Street Sheffield S1 2AB YORKSHIRE 0114 2345678

No commas! no nothing to seperate it. Is it possible to seperate? So you have Title, Initial(s), Address, county, telephone.

Some don't have the telephone number but on a first check all have the rest of the details.

So is this possible? :huh:

If your data is perfect, you can do this using the Text to Columns function.

Highlight the data, Click on 'Data' at the top, then select 'Text to Columns ...', select 'Delimited', then 'next' then click in the box for 'space' then 'next', select the destination e.g. B1, 'finish'.

If the data isn't perfect e.g. some roads have three parts to their name, you'll need to do a lot of unpicking.

good luck.

Thanks for that Tricky, will go ahead and try.