Convert cell or range value from text to number

data is: number and number with CR before. i want to keep them both