Move 9 columns of data in Column B that are seperated by spaces & place in columns C - J

Data looks like this.
Note - Some rows have numbers in them, some end with a comma

Xxxx xxx xxxx xxx xxxx - xxxx, 34.00 LF 0.87 0.59 6.04 36.21 (0.00) 36.21
Xxx Xxxxxx Xxxxx - 3/4" 33.60 LF 1.40 1.23 9.64 57.91 (0.00) 57.91
Xxx 1/2" Xxxxxxx - Xxx, Xxxx, 32.00 SF 1.94 1.10 12.64 75.82 (0.00) 75.82
Xxxxx Xxxxxx Xxx - 1 xxxx 6.00 LF 1.03 0.07 1.26 7.51 (0.00) 7.51

Using the last row as an example, need to end up with the data in C - J as follows
(Working from column J to column C)
Column J - 7.51, I - (0.00), H - 7.51, G - 1.26, F - 0.07, E - 1.03, D - LF, C - 6 and the balance of B left in B Xxxxx Xxxxxx Xxx - 1 xxxx

Have about 200 rows to do every few days so really appreciate your help

The issue is with your initial text

R&R 1/2" drywall - hung, taped,
R&R Quarter round - 3/4"
Paint window sill - 1 coat

It doesn't follow any specific pattern that we can have Excel use to separate it.
If you can separate that manually, then the rest can be separated by "Text To Columns" using Space as a delimiter.

If I missed a pattern, let me know.

Okay, you gave me an idea. First, position the active cell where you plan on separating your data. In my spreadsheet, it was cell A12. Then go to defined names (Formulas>Name Manager), new name

Please Login or Register  to view this content.

In A12 copied down
=MID(A2, 1, FIND("^", SUBSTITUTE(A2, " ", "^", NumSpaces-7)))

In B12 copied across to H and down
=MID($A2, FIND("^",SUBSTITUTE($A2, " ", "^", NumSpaces-8+COLUMNS($B$12:B$12))),FIND("^",SUBSTITUTE($A2, " ", "^", NumSpaces-8+COLUMNS($B$12:C$12))) - FIND("^", SUBSTITUTE($A2, " ", "^", NumSpaces- 8+COLUMNS($B$12:B$12))))

In I12 copied down
=RIGHT($A2, LEN($A2)-FIND("^",SUBSTITUTE($A2, " ","^",NumSpaces)))
See attachment
Questions?

Just line up the formula's to the right of the data instead of below. Make sure that your active cell is in the same row as your first set of data when making your defined name. See attachment.

If you want to then delete column A, Copy >Paste Special Values over top of the formulas to convert them to constants.

Can you upload a new exaample (Go Advanced>Manage Attachments)

Are you asking for a complete macro solution? or a macro to set up the defined name?