right align columns

Try this:

1) First, you need to find the text with the most spaces in it. Let's call this value 'x'. Load the data into a spreadsheet as it is.

2) Insert a column so data is in column B

3) In A1, enter
=LEN(B1)-LEN(SUBSTITUTE(SUBSTITUTE(B1," ","")," ",""))

4) Copy this value down column A
Column A now contains the number of spaces in each text string

5) Sort column A in reverse order and make a note of the contents of A1. This is the text with the most spaces in it. Call this value 'x'.

6) Undo the sort so everything is back in its original order.

7) Enter this formula in C1 and copy it all the way down Column C

=REPT(" ",x-A1)

Remember 'x' is the value that was in A1 and represents the maximum spaces in a line of text. So in step 5) if the value in A1 was 9 you'd enter
=REPT(" ",9-A1) above

8) In D1 enter and copy this formula down column D

=C1&B1

Youve now padded out each text line with extra spaces so each text line now contains the same number of spaces or words.

9) Copy Column D

10) Paste Special - Values, back to column D

11) Select Column D

12) Use Data - Text To Columns - Delimited
Click space and make sure "Treat Consecutive Delimiters As One" is unticked

You should now have right justified columns in Columns D, E, F etc

So just delete the columns A, B, C