Jan 11 2022 05:06 PM
Hi I'm trying to format cells to always remove any characters from any string that dropped into the cell and only keep numbers. I'm running
Microsoft® Excel® for Microsoft 365 MSO Version 2111
I'm collecting data from a program and the string starts with a series of letters then a colon (:) then numbers. After importing the data and dropping it into Excel, I then have to go in and remove the letters and colon. If I could format excel to remove the letters and colon, it would be a big help
Jan 11 2022 07:36 PM