Add two new columns in Excel and use formulas: one that extracts the number and one that extracts the name. It works best when the cell is built as "number space text", for example "401 Groundwork".
How to do it
Insert two new columns next to the column with number and name.
In the first, enter a formula that extracts the text before the first space, for example =LEFT(A2,FIND(" ",A2)-1).
In the second, enter a formula that extracts the text after the first space, for example =MID(A2,FIND(" ",A2)+1,200).
Make sure A2 points to the cell with the combined text.
Copy the formulas down the entire column.
Use the new columns as number and name when you import via the three dots next to the project name → Import data.
Good to know
If the cells are structured differently, for example with a hyphen or several spaces, you may need to clean up manually.
If you use Norwegian Excel, the functions are called VENSTRE, FINN and DELTEKST, and the separator is a semicolon.