Copying Numbers Only From A CellJul 2, 2009
I have a list of data in Column D of a spreadsheet. The cells contain a mix of text and numbers which is variable. Sometimes it could be "Internet 645" and sometimes it could be "VB456774" or lots of other combinations. Sometimes there are spaces, and sometimes none, and sometimes there is no numbers.
Is there a way to select Column D, copy out just the numbers only (w/o spaces or text or special characters" and copy to a new Column?
A demo could be:
So that once processed, a new columns would show:
(notice that if there are no numbers in a cell, i would like all the data below it to be pushed up when pasted into the new column)