I thought you might have had single spaces within text that you would
not want to split, hence the suggestion to change 2 spaces to some
other character and use that as the delimiter. Anyway, I glad you
sussed it in the end.

Pete

On Dec 21, 12:35*pm, Colin Foster
wrote:
Pete, Otto & Ron,

Thanks for your responses.

Ron, can't do the fixed width as there are different spaces used, so the
columns don't align
Otto, yours works (forgot that TRIM takes out all intermediate spaces (bar
one))
Pete, your solution gave me an answer, but not exactly as planned - I forgot
that you can set the Text to Columns to treat consecutive delimiters as one,
so I just need to do a straight forward T2C.

Sometimes, I feel like the Great Homer "Doh!"

I'll blame my stupidity on this cold!!

Happy Christmas & thanks for your assistance
Regards
Colin



"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!- Hide quoted text -

- Show quoted text -