How do I convert "3 days" to 3 in Microsoft Excel for OSX
Select the column of data.
Choose Data → Text to Columns.
Excel should determine the data is delimited. Choose Next.
Tick Space as the delimiter. The preview should indicate the data is split correctly.


For the first column of numbers, leave General selected as the format. If you don't wish to keep the text in a column to the side, select the second column and choose Do not import column.


Choose Finish to complete.