Separating out strings

  • Thread starter Thread starter wutzke
  • Start date Start date
W

wutzke

I have a series of strings in column A that contain something like

-MSC 04 MISCELLANEOUS 133 166 296 262 0 0 0 0 0 0 0 0 856

The last 13 groups of numbers represent counts per month. In the above
example 133 is January, 166 is February, 296 is March...with the last
number the total of all months.

How can I separate each number into columns with the month as header?
 
Maybe...

Select the column
Data|Text to columns
From that single line of data, maybe you could use delimited (by a space) or
fixed width.

This will parse the data into separate columns.

Add headers to row 1 if you want.
 
Back
Top