Assalam-o-alaikum!
I am using excel 2010. I have an excel sheet in which character and numbers are mentioned in one cell per raw and the data is in thousands of raws. Following is the example of few: -
A A BBBBB CCCC 012354-2 1,283,228
D D YYYY 066666-1 3,749
Y Y MMMMM 123564-5 175,095
BBBBBB UUUUU 2356489-7 5,192
I want to remove all numbers that contain "-" sign. Like I want to remove 012354-2, 066666-1, 123564-5 and 2356489-7 but I want to keep character with abc and numbers mentioned with ,. like 1,283,228, 3,749, 175,095 and 5,192. I want data to appear as under: -
A A BBBBB CCCC 1,283,228
D D YYYY 3,749
Y Y MMMMM 175,095
BBBBBB UUUUU 5,192
Could you please advise how I can do it? Is there any find and replace command, which finds number with dash sign and removes it on entire sheet?
Bookmarks