Formatting a number as text

Hi!

One of my data sets has a column of data that is created by a formula in the Excel spreadsheet the data set is sourced from. Some items in the column are numbers like "2413" while others are a combination of numbers, spaces and letters "3425 DEL".

When I load this data set into Power BI I get an error. In the Query Editor, all items in this column that contain letters are shown as 'error'.

I think that this is a problem with the format of either the source Excel spreadsheet or of the columns in Power BI but I haven't been able to figure out the solution.

Does anybody have any ideas on how to get Power BI to load these items?

Thanks!