Hello All,

Is it possible to create a macro that will go through a column of cells and remove only the text leaving a number? I have imported many cells that have for example "Size:342". I would like to be able to have a macro go through and delete all the text just leaving the number. Is this possible?

Thanks