I have a large set of data that was copied into Excel from a word document. As a result, each line of data from the word document is entered into a single cell in Excel.

To separate the data, I ran "text-to-columns" with space as the column break. Because some of the categories of data rows have different amounts of words, there are varying amounts of columns in the rows of data. Currently, the left-most columns are aligned, but if I want to run totals on the data, I need to align the right-most columns. To make it a bit easier, for each row, the right-most column has the letter "A" entered into it. It looks something like this, where each word/number would have its own column:



Melon 1,221.09 44 2,055.75 A
Mustard 5.86 1 3.52 A
N-Grnhs Plants In Containers 67.56 79 373.91 A
N-Grnhs Transplants 16.7 6 8.8 A
N-Outdr Flower 154.86 26 473.75 A
N-Outdr Plants In Containers 1,412.45 952 1,667.93 A
N-Outdr Transplants 179.42 25 128.22 A
Nectarine 356.69 14 103.5 A
Olive 17,329.60 104 3,930.80 A
Orange 14,763.53 73 1,190.32 A
Pastureland 1 1 1 A
Peach 746.69 24 218.7 A
Pear 3,790.26 36 1,670.50 A
Pepper, Fruiting 539.84 21 707.65 A
Pepper, Spice 40 1 20 A
Pistachio 7,098.80 55 7,249.26 A

Basically, I need to shift the rows so that the two right-most columns align (the "A" and the number before it).

Thanks in advance.

If you want to post a workbook with sample data BEFORE/AFTER in it, I can see what I can do.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.