Find and Replace query

Copper Contributor

I have copied and pasted data into a spreadsheet but the headings have ended up in the same cell as the number values I need.... I don't want to find a specific set of letters, I want to find all letters and delete them to leave only the numbers that were in the cells with the letters.....can I use find and replace to find cells containing number and letter values and replace with only the number values remaining?

MissMoz_1-1659229605561.png

 

MissMoz_0-1659229190834.png

 

1 Reply

@MissMoz 

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.