Yeah, it's also cold and snowy in Warrington !!

Rather than use a formula, you might be better off using some
commands. Find & replace (CTRL-H) will allow you to replace, say, 2
spaces with another character (like "|"). Then you can check down your
column to see that this is what you want. Then you could do Data |
Text-to-columns using that pipe character ("|") as the delimiter,
setting Treat multiple delimiters as one. Finally, use File | Save As
to give the file a different name, so that you still have the original
if you need it.

Hope this helps.

Pete

On Dec 20, 3:58*pm, Colin Foster
wrote:
Hi,
Trying to sort out a spreadsheet that someone's given me... a type-up of a
WW2 pilot's logbook.

For one set of information (pilot flying times) has been typed in a single
column using the Spacebar to line up the 4 columns of data (rather than using
4 separate columns).

So, what I want to do is to convert this. So, what I thought was to replace
the spaces with a single comma between each set of data which I could then do
a data parse to separate. Unfortunately, there are various number of spaces
between each of the sets of data, so any suggestions of a quick way of doing
this?

The way that I thought was to use the SUBSTITUTE function & somehow use a *
wildcard to allow it to deal with different numbers of spaces, but either I'm
doing it wrong, or it can't be done that way.

Any suggestions?

Cheers from a snowy & cold Manchester!