Forum Discussion
Find and Replace query
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?
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.
